Error 1004: Unable to Set Hidden property of the range class...

Hello friends....

I have two macros one for an ActiveX Control to hide/unhide rows and another macro for inserting dates and the Worksheet is protected with a password....the macros are as follows for reference
....when I click ActiveX Control...a message..Error '1004' Unable to Set hidden property of the range class appears...

I am unable to find out where the code is wrong and what to do.....

Please Login or Register  to view this content.

Thanks in advance...

Originally Posted by Andy Pope

is Sheet1 the sheet you are hiding rows on?

The error would suggest the active sheet is protected.

Dear Andy,

Thank you for considering my problem....

Yes, Sheet 1 has few hidden rows and which can be unhide as per requirement of the client/user by using an ActiveX control.

Jay

Originally Posted by Winon

Hi jaysakle,

Please try:

Please Login or Register  to view this content.

Regards

Dear Winon,

Thanks a lot...

I tried the code suggested by you....it works nicely...but works only one time...it unhides the rows but unable to hide the same rows when click again....

Please suggest what to do to rectify it....

Thanks again

Originally Posted by Winon

Hello jaysakle,

Will it always be the same rows to Hide or Unhide, or do you want the user to choose which rows to Hide or Unhide?

Hi Winon,

Yes, the same rows always to be hide or Unhide.... on clicking the ActiveX Control.

Image is inserted for your kind reference....2013-10-03_112346.jpg

Regards