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: 1
Default Protected Sheets suppressing object usage

Using a combination of my own intellect and the Microsoft "Learning Tools" online section (I'll trust anything before Microsoft), I've tried everything available to make an object usable after protecting an Excel 2000 spreadsheet, but I keep getting the "The cell or chart you are trying to change is read-only yada yada..." error. In this case, the object is a checkbox, and checking the box will enter an amount into a linked cell. The linked cell itself is unprotected. I've tried unprotecting the checkbox, and that hasn't worked; I've unchecked the "Object" box while protecting the sheet itself, and that hasn't worked either. As it stands, a protected sheet will not allow a user to check or uncheck boxes, and therefore my sheet is useless. What can I try next? Will anything else work?
 
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
insert object worksheet protected Wanna Learn Excel Discussion (Misc queries) 2 January 21st 09 07:03 PM
protected sheets Jock Excel Worksheet Functions 3 December 4th 07 12:51 PM
lock position of Word object in protected excel spreadsheet dheitz Excel Worksheet Functions 1 October 1st 07 12:53 PM
lock position of Word object in protected excel spreadsheet dheitz Excel Discussion (Misc queries) 1 September 27th 07 01:09 PM
How do I insert an object onto a protected worksheet? Arthur.awg Excel Discussion (Misc queries) 0 March 21st 06 01:36 PM


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