Unprotection For ActiveX Control

A

Abe

I have a protected sheet but would like others to
manipulate Spin Buttons (ActiveX variety) to change some
of the data. But if the sheet is protected I can't use
the spin buttons even when the cells to be manipulated
are unprotected AND the spin buttons are unlocked. Is
there ANY way to get around this without having to
unprotect the entire sheet every time I use the spin
buttons??

Thanks,

--Abe
 
D

Dave Peterson

Do you have a linkedcell? Is that cell locked?
Can you unlock that linkedcell?

You could put the linked cell on another sheet (or even in an unlocked hidden
cell (hidden column or hidden row) and then use another cell that shows the
value of that hidden cell.

(that linked cell could be on another worksheet if you want.)
 
A

Abe

Dave,

Thanks! Putting the linked cell on a different worksheet
from the spin button did the trick. Both worksheets are
protected but it works now. Very strange...

--Abe
 
D

Dave Peterson

If I had that linked cell on a protected worksheet (any protected worksheet) and
that cell was locked, then it wouldn't work for me (xl2002).

Any chance that the worksheet was protected, but the cell wasn't locked?
 
Top