LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Locking columns and not protecting whole sheet

Yes.

The users can input data in the "unlocked" cells, which would be all the other
columns.

When you hit ToolsProtectionProtect Sheet you will be presented with a list of
options for users.


Gord Dibben MS Excel MVP


On Thu, 13 Jul 2006 11:39:40 -0400, changetires
wrote:


If I protect the whole sheet can I still have people input data without
having to log on with a password?


 
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



All times are GMT +1. The time now is 03:13 AM.

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"