Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Control Button Name
I have 2 Form Control Buttons that I have assigned macros to in Worksheet 1.
In one of the Buttons, my macro (among other things) copys Sheet 1 from Worksheet 1, and pastes it into a New Worksheet and attempts to delete the Control Buttons. The problem is, in Worksheet 1, my Control Buttons are named "Button 4" and "Button 48". When Sheet 1 from Worksheet 1 gets copied to the New Worksheet, the Control Buttons names change ("Button 2" and "Button 3" in one test and "Button 4" and "Button 5" in another test on a different machine). How can i overcome this? (is there a wildcard i can use to specify deleting all Control Buttons? or can i fix the name of he Control Button name when being copied to the New Worksheet?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Control Button Color | Excel Discussion (Misc queries) | |||
Button in Form Control | New Users to Excel | |||
How to see which Marco is assgined to a form control button | Excel Discussion (Misc queries) | |||
Form Control Button Offset | Excel Programming | |||
Customizing Form Control Button in 2007 | Excel Discussion (Misc queries) |