Error 1004

Hello,

I've created an excel sheet (see attachment - tabsheet 1) where users can only fill in the cells in grey, remaining white cells are password protected to prevent them from editing.
I've created now a VBA code to hide / unhide certain rows based on input given in the tabsheet, however when I password protect this sheet I receive follow error:

Please Login or Register  to view this content.

VBA code works, password protection works, but the combination of the two doesn't work. Any idea what causes the issue?

Thanks for the help.

Edit: if I post my VBA code in the [code] brackets I get a firewall acces denied.. However, my VBA code is in the excel example.

Add the highlighted fragment at the beginning of the procedure:

Please Login or Register  to view this content.

Artik

Hello Artik,

Works perfectly, much appreciated for the prompt response!

Cara Pils