Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
button
how can i check if a button already exists in a certain sheet on opening of
a file? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
button
What sort of button, forms, control tolbox?
If the former try Dim oBtn As Object On Error Resume Next Set oBtn = ActiveSheet.Buttons("Button 1") If Not oBtn Is Nothing Then MsgBox "Button 1 already exists" End If If the latter, then Dim oOLE As Object On Error Resume Next Set oOLE = ActiveSheet.OLEObjects("CommandButton1") If Not oOLE Is Nothing Then MsgBox "already exists" End If -- HTH RP (remove nothere from the email address if mailing direct) "luc" wrote in message ... how can i check if a button already exists in a certain sheet on opening of a file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming |