Macro not working when protecting sheet

[stenmark]

Hi

-------------
Rows("22").Select
Selection.EntireRow.Hidden = False
Range("A1:C1").Select
-------------

Working fine until I protect the sheet...
Excel gives error message saying "property hidden cant be used for class range"....anyone know how to get around this?

Thanks in advace

 

[dumbo40]

have you tried unlocking the macro button before protecting the worksheet?

 

[erik.van.geit]

Hi, stenmark,

try something like this

ActiveSheet.Unprotect
Rows("22").EntireRow.Hidden = False
Range("A1:C1").Select
ActiveSheet.Protect

depending on your version there is a setting to allow "row-edits", when you protect a worksheet, but you don't seem to have Excel 2002 or higher (I think it was not there in 2000)

attention:
you don't have to select the row to edit it (see code without select)
kind regards,
Erik

 

[stenmark]

thanks! =)