How to cause Excel to trigger a procedure without the user opening a workbook.

  • Thread starter Thread starter Dominique Schroeder
  • Start date Start date
D

Dominique Schroeder

Hi,

I'm curious to know if it is at all possible to have the Excel application
trigger a procedure everytime Excel is launched.
In other words, the user launches Excel and a procedure would automatically
be run without him/her having to open a specific workbook.

thanks,

Dominique
 
Hi Dominique,
Well..., yes and no.
You can create an Auto_Open() sub and place it in your (or your users)
personal workbook.
If you do tools>macro>record new macro. When the window opens select "In
personal workbook" in the "store macro in" drop down box.
You can always rename or edit it later.

It does "open" whenever Excel is launched, but it remains hidden to the user
except in the VBA editor.

--
John
johnf 202 at hotmail dot com


| Hi,
|
| I'm curious to know if it is at all possible to have the Excel application
| trigger a procedure everytime Excel is launched.
| In other words, the user launches Excel and a procedure would
automatically
| be run without him/her having to open a specific workbook.
|
| thanks,
|
| Dominique
|
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is removing Macros from workbook 3
Opening a workbook opens two 4
Edit VBA Code without opening the workbook 9
How can I force a workbook to close? 6
Custom Document Properties in Word documents and Excel workbooks 13
Which Excel event to call when opening a .txt file 1
Out of resources error message - when not... 3
Open a Workbook using VB 2

Back
Top