Macros and protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unable to protect cells in macro sheet b/c runtime error 1004 1
Macro to copy value in field and insert it into filter 2
Run Macro If Cell have "x" value 0
Pasting cell contents into a macro 1
Collapsing all groups 0
Protected cells can't be grouped 1
Cell/worksheet protection with macros enabled 7
excel 2007 macro recorded pivot table 2

Back
Top