Modify Protection Macro to allow formatting?

  • Thread starter Thread starter Visakha
  • Start date Start date
V

Visakha

Option Explicit
Sub UnprotectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.unprotect password:="topsecret"
next wks
End Sub
Sub ProtectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="topsecret"
next wks
End Sub

How do I modify to allow users to format cells?
 
Only been 4 minutes since your first post.

Have a little patience.

See reply at that post.


Gord Dibben MS Excel MVP
 
Apologies! I have had problems in the past posting and thought that the post
got lost. Thanks!
 
Back
Top