Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SusanM
 
Posts: n/a
Default Cell Protection

I have a worksheet with five columns that contain IF formulas (Group A)
linked back to other columns in the same worksheet (Group B). I need to
protect the formulas in those five columns (Group A), so that they cannot be
deleted/changed. I have followed the correct procedures to lock the specific
cells and password-protect the worksheet.

One of the columns in €śunlocked€ť Group B contains links to two other files.
The users need the ability to change the links to other file sources. When
the columns in Group A are locked and protected, the user cannot change the
file links.

Is there anyway around this restriction?


 
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
VBA code error with Protection turned on - help please Fred Excel Discussion (Misc queries) 1 March 17th 06 04:06 PM
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
Cell Protection Issue Ket Excel Worksheet Functions 1 May 11th 05 01:10 AM
cell protection D Excel Discussion (Misc queries) 2 March 29th 05 10:58 AM
Conditional formating - cell protection Bdavis Excel Discussion (Misc queries) 0 February 11th 05 09:15 PM


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