Macros on Protected worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
2 ways.

1 - Change the protection to allow macros to modify the sheet. This requires
the addition of a parameter to the protection

Sheets("Sheet1").Protect UserInterfaceOnly:=true

2 - Unprotect the sheet. Run your code. Reprotect the sheet

Sheets("Sheet1").UnProtect Password:="Whatever"
'Your code here
Sheets("Sheet1").Protect Password:="Whatever"
 
Thanks! I'll give it a try.
--
Ronnie


Jim Thomlinson said:
2 ways.

1 - Change the protection to allow macros to modify the sheet. This requires
the addition of a parameter to the protection

Sheets("Sheet1").Protect UserInterfaceOnly:=true

2 - Unprotect the sheet. Run your code. Reprotect the sheet

Sheets("Sheet1").UnProtect Password:="Whatever"
'Your code here
Sheets("Sheet1").Protect Password:="Whatever"
Click to expand...
 
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

Protect and Unprotect all worksheets with macro 2
Macro protection problems 1
modify macro to include more tabs 1
problem with macros and protections 5
Protecting a macro 4
password protection macro - HELP???? 4
Run Macros in a Password-protected workbook? 1
Protection macro 4

Back
Top