Protecting & Unprotecting worksheet

[Guest]

Hi,
I have a worksheet that when the user checks a certain checkbox certain rows
and checkboxes are hidden. This sheet needs to be protected, but when I
protect the sheet and click on the checkbox I get an error in the code that
hides the rows. Works fine when the sheet is not protected. Any ideas???

 

[Bill Renaud]

Tammy wrote:
<<...when I protect the sheet and click on the checkbox I get an error
in the code that hides the rows.>>

You probably will have to unprotect the worksheet before trying to hide
or unhide the rows. Protect the worksheet the very last thing.

Please post your code, if you need more specific help (as always in this
newsgroup).

 

[Alain Vaillancourt]

You need to use the Unprotect method of the Worksheet at the begining of
your code and the Protect method at the end.
As the password will appear in the code, you will need to "Lock project for
viewing" if not already done.

 

[Guest]

I was able to use the Unprotect and protect methods.

Thanks for everyones help. I can always count on this group.

Tammy