This is so frustrating. When you password protect your sheet you can filter
if you tick ALL the options but you can't use the ShowAll feature. Does any
one know how to unprotect sheet then select ShowAll then re protect? When I
attempt to do it then run the macro it keeps asking for a password. I don't
want users to have to use a password. I would like the macro to type the
password instead.

Worksheets("somesheetnamehere").unprotect password:="what's the password"
'do your stuff
Worksheets("somesheetnamehere").protect password:="what's the password"



checkQ wrote:

This is so frustrating. When you password protect your sheet you can filter
if you tick ALL the options but you can't use the ShowAll feature. Does any
one know how to unprotect sheet then select ShowAll then re protect? When I
attempt to do it then run the macro it keeps asking for a password. I don't
want users to have to use a password. I would like the macro to type the
password instead.

--

Dave Peterson

Thanks so much Dave. It worked!

"checkQ" wrote:

This is so frustrating. When you password protect your sheet you can filter
if you tick ALL the options but you can't use the ShowAll feature. Does any
one know how to unprotect sheet then select ShowAll then re protect? When I
attempt to do it then run the macro it keeps asking for a password. I don't
want users to have to use a password. I would like the macro to type the
password instead.