Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling all pushbuttons
I added one pushbutton on top of my Sheet1. I then
right-clicked that button and selected "Copy. Next, I pasted multiple instances of that same button on Sheet1 up to Sheet12. So, basically, I have many instances of the same button scattered through sheets 1 to 12. What is a good way to disable (and enable) all these scattered buttons??? Do I need to iterate through all buttons and disable them one at a time?? How do I do this? thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling all pushbuttons
For Each sht In Sheets For Each obj In sht.OLEObjects ObjectType = TypeName(obj.Object) If ObjectType = "CommandButton" Then obj.Enabled = False End If Next obj Next sht -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170670 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
editting pushbuttons | Excel Programming | |||
disabling cells | Excel Programming | |||
Disabling Alt+F11 | Excel Programming | |||
Disabling Keys | Excel Programming | |||
Disabling Macros | Excel Programming |