ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro running before all others (https://www.excelbanter.com/excel-programming/288377-macro-running-before-all-others.html)

Stewart[_3_]

Macro running before all others
 
Is it possible to set up a macro which you'd like to run
before all other macros without calling it from every
macro.

Hope that makes sense and that there's a solution - or
I've got a long day ahead calling macros...

Thank you

Stewart

Bob Phillips[_6_]

Macro running before all others
 
You could add it to the workbook open event, it will be the first thing run
then.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stewart" wrote in message
...
Is it possible to set up a macro which you'd like to run
before all other macros without calling it from every
macro.

Hope that makes sense and that there's a solution - or
I've got a long day ahead calling macros...

Thank you

Stewart




Beto[_3_]

Macro running before all others
 
Bob Phillips wrote:

You could add it to the workbook open event, it will be the first thing run
then.


That may be a solution but I think he wants this macro to be run
everytime another macro is executed, so I think he'll have to call it
from every macro. I'm no expert, but I believe he can create a macro to
automate the process of adding this call into every macro.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.



All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com