LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dave123
 
Posts: n/a
Default Password Protection


I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?

Thanks in advance.
Dave


--
Dave123
------------------------------------------------------------------------
Dave123's Profile: http://www.excelforum.com/member.php...o&userid=27748
View this thread: http://www.excelforum.com/showthread...hreadid=472638

 
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
Password Issue keithl816 Excel Discussion (Misc queries) 6 July 10th 05 06:20 PM
Password protection for Excel sheets Alejandro Excel Discussion (Misc queries) 2 April 13th 05 03:33 PM
Changing password protection on sheets Tom Hewitt Excel Discussion (Misc queries) 5 February 25th 05 03:33 PM
How to define separate Password Protection, to say 3 persons, for. Sreeraman Thillaisthanam Seshadri Excel Worksheet Functions 1 December 17th 04 09:15 AM
Password protection andy Excel Discussion (Misc queries) 1 December 7th 04 02:51 PM


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