Protect then reprotect using macro

[Guest]

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]

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

 

[Guest]

Thanks so much Dave. It worked!