MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Neo, I need some additional help (Re: Macros on protected document)

Posted by Chris Jones on August 15, 2001 9:36 AM

I did what you said, but it didn't work. I got a statement that said:

'Run Time Error 1004'
'Unable to set the Hidden property of the Range Class'

The following line was highlighted when went to the debugger:

Selection.EntireRow.Hidden = False

I tried it without a password that looked like this:

Selection.EntireRow.Hidden = False
Selection.EntireRow.Hidden = True

I also tried it with a password and it didn't work

Posted by Chris Jones on August 15, 2001 9:43 AM

Sorry Neo,

I just figured it out. I had the wrong sheet number corresponding, it was sheet2 instead of sheet1.

Thank you very much for your help, this was very important

Posted by neo on August 15, 2001 9:51 AM

glad you got it...

to do it without a password, just leave the ("") off completely : sheet1.protect

I'm glad I could help...