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?

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?