Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable running of SelectionChange macro when in another macro? Tonso Excel Discussion (Misc queries) 6 March 21st 10 06:50 PM
Macro Not Running Akash Maheshwari Excel Discussion (Misc queries) 2 January 16th 08 02:00 PM
Event Macro running another macro inside K1KKKA Excel Discussion (Misc queries) 1 December 20th 06 08:21 PM
disable user running macro from Tools Macro Steve Simons Excel Discussion (Misc queries) 4 September 28th 06 06:28 AM
Launch Macro in Access via Macro running in Excel??? dgrant Excel Programming 1 September 24th 03 01:38 PM


All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"