Modify Protection Macro to allow formatting?

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?
 
G

Gord Dibben

Only been 4 minutes since your first post.

Have a little patience.

See reply at that post.


Gord Dibben MS Excel MVP
 
V

Visakha

Apologies! I have had problems in the past posting and thought that the post
got lost. Thanks!
 

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

Protection Macros--modify to allow format changes 2
renaming tabs based on a on a worksheet 2
Filtering Worksheets by Same Criteria - Object variable or with blockvariable not set 5
Inaccurate count with code 6
Stubborn array wont change destination worksheet - HELP! (reposteddue to incorrect formatting) 2
Array to specific worksheet - nothing seems to work 2
Apply macro to all worksheets 15
Protection to add a line to Remove "Select Locked Cells" ??? 1

Top