Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to activate form button
I don't know of a way to simulate the clicking of a forms toolbar butto
so that the Application.Caller shows up as the button name, but I hav another suggestion. 1. Create a global variable in a standard module: Public gbln_ExitOK As Boolean 2. Set it to False in your Workbook_Open event procedure. 3. Set it to True when you button is clicked or when the macro runs. 4. Check for it to be true instead of checking Application.Caller -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to activate form button
Thanks, that worked great, and was a much easier way to go about thanks
Thanks again Ji ----- kkknie wrote: ---- I don't know of a way to simulate the clicking of a forms toolbar butto so that the Application.Caller shows up as the button name, but I hav another suggestion 1. Create a global variable in a standard module Public gbln_ExitOK As Boolea 2. Set it to False in your Workbook_Open event procedure 3. Set it to True when you button is clicked or when the macro runs 4. Check for it to be true instead of checking Application.Calle -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro attached to command button - VBA form | Excel Discussion (Misc queries) | |||
Activate a form ? | Excel Discussion (Misc queries) | |||
button in a cell to activate a macro | Excel Worksheet Functions | |||
Form Buttons Connected to a Macro - Want to remove the button | Excel Worksheet Functions | |||
Attaching a macro to a VB button on a form | Excel Worksheet Functions |