LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Locking all cells

I have a workbook which to open you have to select Edit or Review from a
DialogBox. If you select Edit you have to get past a password and then you
can make certain editing changes. If you select Review you can open the
Workbook (and print) but can not make any changes. Well at least that's my
plan. Is there any way to lock down a worksheet so that someone can not
even select a cell? When someone selects Edit they get a worksheet which has
some locked cells but can edit others cells, so I can not just format all
cells to lock or they would loose their ability to edit.


 
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
Locking cells P. Zicari Excel Worksheet Functions 1 October 24th 07 11:42 PM
Cells Locking? Norm Excel Discussion (Misc queries) 7 June 19th 07 02:45 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
Locking cells Deepwater Excel Discussion (Misc queries) 2 September 7th 05 04:07 PM
Locking Cells WendiW Excel Discussion (Misc queries) 1 March 10th 05 08:15 PM


All times are GMT +1. The time now is 02:19 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"