LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide/Unhide after protect sheet RKS Excel Discussion (Misc queries) 0 March 21st 08 05:03 AM
How do I set up a column tool to hide/unhide? pufimic Excel Discussion (Misc queries) 1 October 27th 06 01:26 AM
hide a column in a worksheet and password protect eoreality Excel Discussion (Misc queries) 1 February 8th 06 02:42 AM
Can I hide a worksheet and set a passwd to unhide it? puneetarora_12 Excel Discussion (Misc queries) 2 July 24th 05 06:06 PM
Can I hide a worksheet and set a passwd to unhide it? puneetarora_12 Excel Worksheet Functions 1 July 24th 05 08:50 AM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"