LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
JimBray
 
Posts: n/a
Default


Karin - try this if I understand your dilema. I dont know what Excel you
are using but in general try this:

1) tools/protection/unprotect sheet

2)select all the cells in your sheet and then format/cells/protection -
uncheck "locked" and when box is unchecked click OK.

3) select your destination cells that you want to protect and then
format/cells/protection - then check "locked" then OK.

4) tools/protection/protect sheet

I don't believe that the user can modify the destination cells now.

Good luck Jim Bray


--
JimBray
------------------------------------------------------------------------
JimBray's Profile: http://www.excelforum.com/member.php...o&userid=24554
View this thread: http://www.excelforum.com/showthread...hreadid=381327

 
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
Excel Display Problem Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 0 April 19th 05 05:25 PM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
workbook protection John New Users to Excel 1 January 22nd 05 12:55 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
How may I remove Office 2003 DRM protection from DOC & XLS files? Locked out Excel Discussion (Misc queries) 1 December 12th 04 05:22 PM


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