Password protecting a sheet, while allowing vba to freely unprotect

[Yeoman.jeremy]

Hi there.

I have recently encountered a problem with my excel program, in which the manager of a particular shop is being very sour about change, and it is my impression that he is purposefully unprotecting and protecting the sheet again after mucking around with little bits of formulae.

I know that I can use a password to prevent people other than myself to unprotect the sheet, but this isn't ideal, as my vba coding requires the unprotecting and protecting of the sheet. is there a way that i can get around having to type in the password everytime i use a piece of code?

Many thanks

 

[Yeoman.jeremy]

ah i see.
I tried to reference the entire workbook, but when i changed to reference just the one sheet it stepped through it fine.

many thanks!