Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Box Run Time Error Cell Locked
I have created option boxes that work great thanks to this forum. My problem is when I enable "sheet protection" and click on the option box I get a run time error that says "the cell is locked." I have formated the cells in and around the option box as "not locked" and then enable sheet protection. Is this the result of some property in visual basic? Thanks in advance -- harksteve ------------------------------------------------------------------------ harksteve's Profile: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501511 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Box Run Time Error Cell Locked
The 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 MVP "harksteve" wrote in message ... I have created option boxes that work great thanks to this forum. My problem is when I enable "sheet protection" and click on the option box I get a run time error that says "the cell is locked." I have formated the cells in and around the option box as "not locked" and then enable sheet protection. Is this the result of some property in visual basic? Thanks in advance -- harksteve ------------------------------------------------------------------------ harksteve's Profile: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501511 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Box Run Time Error Cell Locked
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: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501511 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Box Run Time Error Cell Locked
Maybe you could put the cell in a hidden column/row. Or put it on a hidden
worksheet. harksteve wrote: 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: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501511 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) |