Spinner Control in a Protected Worksheet

C

cskgg

:confused:
MS EXCEL 2002.
Hello. I inserted a "Spinner Control" in my worksheet. I also remove
its protection (Format Control > Protection tab > removed the checkmar
in the "Locked" option).
Then I protected the worksheet as I do not want the users to make an
changes - BUT I WANT THEM TO USE THE SPINNER TO TOGGLE BETWEEN M
PRESET VALUES.

PROBLEM FACED:
After Protecting the sheet, if I click on the spinner control, th
system does not allow and says "The cell or chart you are trying t
change is protected and therefore read-only."

FILE ATTACHED: protected without a password.

Any suggestion / solution?
Thanks/cskgg
This should not happen

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

Dave Peterson

I don't open workbooks.

But try unprotecting your worksheet, unlock that linked cell, and reprotect the
worksheet.

Format|cells|protection tab (is where you'd change the "lockedness" of a cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spinner Control and Protected Worksheet 2
Excel Spinner Control disabled 1
Protected worksheet allow users 1
Link a Spinner to a combo box control 2
Hyperlink in protected worksheet 4
Enabling Autofilter and Sorting in a Protected Sheet 2
Using Outline commands in a protected worksheet 6
corrupted formula in protected worksheet 21

Top