Macros and buttons
Hi
I get the gist of it but how do I find the "name" of the buttons, - stupid
question but I am dumb at controls etc
Sandy
"JE McGimpsey" wrote in message
...
One way:
Attach macro A to button C. In Macro A, include the lines:
Worksheets("Sheet1").Buttons("Button C").Visible = False
Worksheets("Sheet1").Buttons("Button D").Visible = True
(adjust the names to suit). Put the opposite configuration in Macro B.
In article ,
"Sandy" wrote:
Hi
I have 2 macros A and B say and two buttons Cand D on a worksheet. Can I
have button C run Macro A and then at the end of the code make C
invisisble
and D visible. Then have button D run Macro B and at the end of the code
make C visible and D invisible - am I making myself clear?
The buttons were placed on the sheet from the form toolbar.
Sandy
|