Macros and protected cells

B

Byers

I wrote a macro to hide cells containing certain data after thei
references were added. It was a schedule and I had the user inser
start date and end date and then hit a button that ran a macro that
hid everything outside of that region. Problem is that I don't wan
the user to be able to change anything on those sheets, but the macr
gave me an error saying it couldn't alter the cells, cause it wa
protected.
Is there a way that I can have the macro break through th
protection? hopefully not as complicated as programming it to type i
the password, but if that is what is needed, then lets do that, but i'
also like it to protect the sheet again after making the change.
I probably won't need actual code, I should be able to figure i
out, if not I'll ask again, just want to know if there's an easier way

-Byer
 
F

Frank Kabel

Hi
use something like

sub foo()
activesheet.unprotect password:="yourpassword"
'your code
activesheet.protect password:="yourpassword"
end sub
 
Top