Macros and protection

S

scott45

I have a sheet that I have recorded a macro to sort columns of information. I
also have the sheet proteceted so certain columns formulas etc do not get
changed. I have discovered (I did not know) that with protection on I can not
run my macro. I get a run time errorDid I do something wrong or is this how
Excel and macros work. If so any suggestions on how to protect this sheet and
still run macros.

thank you
Scott
 
B

Barb Reinhardt

I'm guessing you'll have to unprotect the sheet before you sort the data and
then reprotect it after it's been sorted within the macro.
 
Top