How to get a macro to run that uses a protected sheet

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

Guest

I would like to create some simple macros (e.g. selecting criteria within an
autofilter and then printing the result) but I would also like to protect the
sheet that contains the Autofiltered data.

When I turn protection on the macro fails.

Is there any way to run macros AND protect sheets?

Thanks
 
In code you need to unprotect then execute your code and then reprotect.
There is no way around it...
 
Have then macro turn protection off and then when done turn it back on:

Sub MyMacro()

Sheets("Sheet1").Unprotect
' Run the rest of your code here
Sheets("Sheet1").Protect

End Sub
 
Activesheet.Protect UserInterfaceOnly:=True
ActiveSheet.EnableAutofilter = True

the autofilter must already exists, but you can change the criteria.

In xl2002 and later, I believe you have to supply the password (if there is
one) when you do the Protect command.
 

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

Macro to password protect and allow autofilter 1
autofilter on a protected sheet 6
AutoFilter Macro Protected Sheet 1
Run Macro on All Sheets Q 8
Pasting cell contents into a macro 1
Restore Autofilter After Macro Runs 1
Autofilter in a macro 1
Copy data using macro (with worksheet protect) 5

Back
Top