Unprotecting sheet in a macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Unprotecting sheet in a macro

FAQ

Thread Tools

Display Modes

11-18-2016, 07:41 AM

ernief

Windows 10 Unprotecting sheet in a macro

Office 2010 64bit

Novice

Join Date: Nov 2016

Posts: 5

Unprotecting sheet in a macro

Hi
I have successfully unprotected a sheet for sorting and then protected it again at the end of a macro button, but if there is a password on the protection it asks for that password before continuing. I do not want to give the password to other users. Can I program the password into the macro.
Thanks

Ernie

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unprotecting just one part of a protected form.	snowboarder2	Word	1	08-24-2016 02:01 PM
Unprotecting specific fields on a Protected Document	Slessor75	Word	3	03-12-2014 02:27 PM
permanently unprotecting a sheet or workbook	mrmagoo	Excel	2	07-04-2012 08:12 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 PM.