Clear Macro & Password Protection
Sub ClearThings()
ActiveSheet.Unprotect Password:="justme"
do your stuff with your code
ActiveSheet.Protect Password:="justme"
End Sub
On Mon, 31 Mar 2008 17:06:50 -0700, Mike wrote:
You might want to post your code so we can see what the clear macro is doing.
"Liz" wrote:
Hi There,
I'm probably midway between basic and moderate excel user.
I have a sheet that has a column that requires users to enter
either y or n, and some other free format info. I have a clear button
that will delete only the free format and y/n entries. I would like to
protect the rest of the other cells so nothing can be changed
(I've unlocked the cells I want people to edit), however, when I
password protect the sheet and then try to run the clear macro, it asks for a
password and unlocks the entire sheet. Any way around this?
|