Anything you can not do manually on a protected spreadsheet will also not
work in a macro... The only exclusion to that rule is if you protected the
sheet in code and added the parameter UserInterfaceOnly:=True. At that point
macros will have some abilities that can not be done manually. That being
said UserInterfaceOnly is a bit hit and miss so it may not be worth doing.
--
HTH...

Jim Thomlinson


"mike" wrote:

Try saving as file type 'macro enabled workbook' in the save as filetype
dropdown. That worked for me with a protected sheet with macros.

"Samantha" wrote:

No im protecting the workSHEET

"mike" wrote:

In my experience, if you protect the workBOOK, macros will not run. They
should still run with a protected worksheet though.

"Samantha" wrote:

Is there any way to make macros work once my document is protected? If so how?