Well you have a choice, you put your password there, you lete the password
prompt pop-up, or you have no password. Your choice.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"widman" wrote in message
...

I don't want to put the password there.
"Bob Phillips" wrote:

You pass the password to unprotect etc.

Activesheet.Unprotect Password:="mypassword"

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"widman" wrote in message
...
Is it possible to protect a sheet (Excel 2003) and still allow macros
buttons
to funcion without adding unprotect and protect at the beginning and
end
(which of course would prompt for the password).