Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have realized that you could run into problems making your option buttons
visible so that you can get into properties to check their names so here is a method of doing so if required:- Ensure that the worksheet with the option buttons is your selected one. Alt/F11 to open VBA editor. Click on menu item Insert then Module. Copy the macro below and paste it into the module. Click anywhere within the code (so the cursor is within the code) Press F5 to run the code. Alt/F11 to return to the worksheet. All buttons should be visible. To get back to the code if required during your development:- Alt/F11 and then expand modules and double click Module1. Sub Identify_Controls() For Each shp In ActiveSheet.Shapes shp.Visible = True Next End Sub Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Unhide option | Excel Worksheet Functions | |||
Hide Unhide Buttons | Excel Discussion (Misc queries) | |||
Hide/Unhide Buttons | Excel Discussion (Misc queries) | |||
I am missing something (hide / unhide rows with buttons) | Excel Programming | |||
Hide/Unhide Option - Need to consider all options! | Excel Discussion (Misc queries) |