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

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