Spinner Control and Protected Worksheet

[cskgg]

I have inserted a SPINNER control in my worksheet > thereafter, I have
REMOVED its "Locked" checkmark (format control > protection). Then, I
protected the worksheet.
When I try to use the spinner after protecting the workseet, the system
says: "The cell or chart you are trying to change is protected and
therefore read-only"!!! VERY VERY FRUSTRATING.
Any suggestions ???? (worksheet enclosed - protected without a
password for testing).

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=625990

 

[William]

Hi cskgg

If you have linked a cell to the spinner button, make sure that linked cell
is unlocked.

--
XL2002
Regards

William

(e-mail address removed)

| I have inserted a SPINNER control in my worksheet > thereafter, I have
| REMOVED its "Locked" checkmark (format control > protection). Then, I
| protected the worksheet.
| When I try to use the spinner after protecting the workseet, the system
| says: "The cell or chart you are trying to change is protected and
| therefore read-only"!!! VERY VERY FRUSTRATING.
| Any suggestions ???? (worksheet enclosed - protected without a
| password for testing).
|
| Attachment filename: test.xls
| Download attachment:
http://www.excelforum.com/attachment.php?postid=625990
| ---
| Message posted
|

 

[Dave Peterson]

You didn't care for yesterday's answer:

http://groups.google.com/[email protected]

If you're looking for old posts, you can use google (maybe a few hours behind)
to search for stuff you've posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm