Hiding rows in protected document using check box as "trigger".

Hello All:

I'm having difficulty in a protected document (protect sheet) for a macro to run that would allow for hidden rows to become visible for data entry and keep document protected once rows are visible. Macro needs to be initiated by a check box.

Also,

Once check box is "deselected" the same rows need to become hidden once again without loosing data contained within those hidden rows.

Please see attached document for more clarity.


Thank you in advance for your help.

Hi there,

See if the attached version of your workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values can be changed to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Greg : It appears to do exactly what I was hoping for! Thank you so much for your efforts.

Where did you place code within document? I'm trying to locate it in "Developer - Macros" and can't see it? And how did you assign it to check box?

I intend to duplicate this process in a few different sheets within document, and I'm not sure I understand how you managed to link to check box and where you have it in document?

Thank you so much, it appears to be just what I was trying to accomplish !

Harold

Hi again Harold,

Many thanks for your feedback.

You're welcome - glad I was able to help.

You'll be able to view the code by entering the VBA Editor (Alt+F11) and clicking on the Modules folder in the treeview there.

To assign the routine to a CheckBox on a worksheet just right-click on the CheckBox and select Assign Macro from the dropdown list.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M