Please see below for my PROTECT WB code. For some reason it is not protecting all sheets like I want it to. Any ideas why would be much appreciated!?!?
Thank you in advance!
Please Login or Register to view this content.
Please see below for my PROTECT WB code. For some reason it is not protecting all sheets like I want it to. Any ideas why would be much appreciated!?!?
Thank you in advance!
Please Login or Register to view this content.
I have macros almost identical to what you've created, you can try out here:
Your code needs to reference each WS in the loop, not the activesheet, look at my code to see what I mean.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks