Protection controlled by macro

[Crownman]

I have a worksheet that is password protected. I want to create a
macro that will unprotect the worksheet, perform several operations,
and then reprotect the worksheet using the same password.

I have tried including the password within the macro to unprotect and
reprotect the worksheet, but I still get prompted for the password when
the macro runs.

Does anyone have any suggestions on how this can be accomplished?

Thanks for any help.

Crownman

 

[Don Guillett]

As ALWAYS, post your coding efforts for comments and suggestions.

 

[Gord Dibben]

ActiveSheet.Unprotect Password:="justme"
'do your stuff
ActiveSheet.Protect Password:="justme"


Gord Dibben MS Excel MVP

 

[Crownman]

Thanks for the answer, Gord. This is exactly what I needed.

Crownman

 

[Gord Dibben]

Thanks for the feedback.

Gord

Thanks for the answer, Gord. This is exactly what I needed.

Crownman

Gord Dibben MS Excel MVP