software

I have created option boxes that work great thanks to this forum. My
problem is when I enable quot;sheet protectionquot; and click on the option box
I get a run time error that says quot;the cell is locked.quot; I have formated
the cells in and around the option box as quot;not lockedquot; and then enable
sheet protection.
Is this the result of some property in visual basic?

Thanks in advance--
harksteve
------------------------------------------------------------------------
harksteve's Profile: www.excelforum.com/member.php...oamp;userid=30483
View this thread: www.excelforum.com/showthread...hreadid=501511The cell the option box(es) are linked to is the culprit - you need to have
this cell unlocked.
If you also want it hidden, hide the column or format the cell as ;;;
Bob Umlas
Excel MVPquot;harkstevequot; gt; wrote
in message ...
gt;
gt; I have created option boxes that work great thanks to this forum. My
gt; problem is when I enable quot;sheet protectionquot; and click on the option box
gt; I get a run time error that says quot;the cell is locked.quot; I have formated
gt; the cells in and around the option box as quot;not lockedquot; and then enable
gt; sheet protection.
gt; Is this the result of some property in visual basic?
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; harksteve
gt; ------------------------------------------------------------------------
gt; harksteve's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30483
gt; View this thread: www.excelforum.com/showthread...hreadid=501511
gt;

Thanks Bob,

These unlocked cells still contain data which is both necessary to the
user
yet vulnerable to accidental overwrite? Is there a solution to this
problem?

Thanks again--
harksteve
------------------------------------------------------------------------
harksteve's Profile: www.excelforum.com/member.php...oamp;userid=30483
View this thread: www.excelforum.com/showthread...hreadid=501511Maybe you could put the cell in a hidden column/row. Or put it on a hidden
worksheet.harksteve wrote:
gt;
gt; Thanks Bob,
gt;
gt; These unlocked cells still contain data which is both necessary to the
gt; user
gt; yet vulnerable to accidental overwrite? Is there a solution to this
gt; problem?
gt;
gt; Thanks again
gt;
gt; --
gt; harksteve
gt; ------------------------------------------------------------------------
gt; harksteve's Profile: www.excelforum.com/member.php...oamp;userid=30483
gt; View this thread: www.excelforum.com/showthread...hreadid=501511

--

Dave Peterson