Hiding rows in locked sheet

[asmith5rgv]

I have a sheet with 2 columns locked containing formulas. Sometimes I have extra rows that do not contain data but since the columns are locked I cannot hide the rows. I want to be able to hid the empty rows while the sheet is locked but it does not allow me to because it is locked. Is there any way around this besides unlocking, hiding and then relocking. I am having a terrible time with my employees unlocking the sheet and messing up a formula then re-locking. I want to be able to keep it locked for good but still be able to have employees hide rows if need be. Thanks in advance.

 

[Smitty]

You can add a button like this:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> HideRows()<br>    ActiveSheet.Unprotect "yada"<br>        Selection.EntireRow.Hidden = <SPAN style="color:#00007F">True</SPAN><br>    ActiveSheet.Protect "yada"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[Peter_SSs]

I have a sheet with 2 columns locked containing formulas. Sometimes I have extra rows that do not contain data but since the columns are locked I cannot hide the rows. I want to be able to hid the empty rows while the sheet is locked but it does not allow me to because it is locked. Is there any way around this besides unlocking, hiding and then relocking. I am having a terrible time with my employees unlocking the sheet and messing up a formula then re-locking. I want to be able to keep it locked for good but still be able to have employees hide rows if need be. Thanks in advance.

Unless you have a very old version of Excel, when you Protect the sheet, look at the list 'Allow all users of this worksheet to:' and tick the 'Format rows' option