Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option button querry
Hi, as usual help please !!
Excel2000. I've made up a work sheet and named it January. It's formatted for data entry. I have then made a column of 12 option buttons labelled January to December. Each option button has its code of sheets.select which is January to December. The original sheet named January was copied 11 times with each sheet re-named February to December. Clicking on an option button take me to the appropriate sheet fine. The niggle is the sheet I go to has all its option buttons blank i.e. no black dot in the middle. I realise the sheet I've just come from has the "illuminated option button". Its no big deal just a niggle but it would just look more professional to have the relevant option button illuminated when on that sheet. What could I have done differently? TIA derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option button | New Users to Excel | |||
option button ? | Excel Discussion (Misc queries) | |||
Option Button Help PLEASE!! | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
value of option button | Excel Programming |