Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marcro updating cell that is "locked"
I have a worksheet that is a survey. Users press radio
buttons evaluating statements on a scale of 1 to 5 (with between 5 and 10 questions per worksheet). On the bottom of the sheet is an average of their score (ie it changes each time somebody selects a different scale on one of the questions). I don't want people selecting the cells (only pushing radio buttons), so I have locked the worksheet. However, when I do this, the macro gets an error when it tries to update the cells with the average score. How do I work around this. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marcro updating cell that is "locked"
One thing you can do is (with code) lock the worksheet with
userinterfaceonly = true. However, you need to do this every time the worksheet opens, otherwise the sheet will revert to regular locked protection. The other option would be to have your code unlock the sheet every time it wants to change the average score, then relock it afterwards. I think setting worksheet.protect userinterfaceonly:=true is the better option. You just need to make sure that the macro knows the password. Mike -- __________________________________________________ __________________________ ________________ Please reply to newsgroup so everyone can benefit. Email address is not valid (see sparkingwire.com) __________________________________________________ __________________________ ________________ "Jim" wrote in message ... I have a worksheet that is a survey. Users press radio buttons evaluating statements on a scale of 1 to 5 (with between 5 and 10 questions per worksheet). On the bottom of the sheet is an average of their score (ie it changes each time somebody selects a different scale on one of the questions). I don't want people selecting the cells (only pushing radio buttons), so I have locked the worksheet. However, when I do this, the macro gets an error when it tries to update the cells with the average score. How do I work around this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
CELL("filename",a1) not updating automatically | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |