View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tiny[_2_] tiny[_2_] is offline
external usenet poster
 
Posts: 1
Default hide, unhide column or row after protect worksheet

Hi everyone,


I go to tool-protect worksheet-enter password and my worksheet is protected.
However, I can't hide or unhide columns or rows afterward. The thing is the
worksheet contains several formulas and I don't want to mess them up after I
enter data into input cell. Plus, I don't want to repeat the same step that
unprotect sheet-hide/unhide rows and columns-protect sheet again. Does anyone
know how to hide or under columns/rows after protect the worksheet with
password?
Please help.

Thanks much,
tiny