Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hit a button with VBA code
Hi,
I'm writing VBA code that is copying data from one file to another. The destination file has 2 buttons (linked to macros) that I need to select with my code. I cannot see the macro code for these 2 buttons, and I think both buttons are using one macro. I think the macro decides what to do based on the button text. So, basically, I'm trying to figure out how to select those buttons with my code. Any help/suggestions?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hit a button with VBA code
Hi,
if i knew which macro would be started by the button, I would call that macro in my code like you call any other sub. Udo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hit a button with VBA code
The thing is, there is only one macro present in that workbook, and
there are a total of 2 buttons in that worksheet. And, the actual macro doesn't do what the other 2 do. I think they have hidden their macro. Regardless, there are 2 buttons I'll need to choose, so I have to be able to choose a button. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code behind command button | Excel Worksheet Functions | |||
How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
Add a Button with code | Excel Programming | |||
Button, but no code | Excel Programming | |||
Button, but now code | Excel Programming |