| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show & Hide Shape in a Sheet
Pete
I think you are overcomplicating things. Private Sub ToggleButton1_Change() ActiveSheet.Shapes("Rectangle 3").Visible = Not (ActiveSheet.Shapes("Rectangle 3").Visible) End Sub will probably do what you want. Good luck. Ken Norfolk, Va |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name of the sheet - hide and show | Excel Discussion (Misc queries) | |||
| Hide n' show cells in protected sheet | Excel Worksheet Functions | |||
| Showing + and - (show and hide) for rows in the sheet | Excel Worksheet Functions | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
| Hide/show sheets by first part of sheet name | Excel Programming | |||
Hybrid Mode
