Protecting & Unprotecting worksheet
 

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???

Protecting & Unprotecting worksheet
 

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).
--
Regards,
Bill Renaud

Protecting & Unprotecting worksheet
 

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.


"Tammy H" wrote in message
...
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???

Protecting & Unprotecting worksheet
 

I was able to use the Unprotect and protect methods.

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

Tammy

"Alain Vaillancourt" wrote:

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.


"Tammy H" wrote in message
...
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???