|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 16th, 2003, 09:11 AM
|
|||
|
|||
Macro
This is a well simple question, but i'm a simple guy, so forgive me....
How do you automate a macro to run when you open up a excel spreadsheet???? 
|
|
#2
July 18th, 2003, 08:24 AM
|
||||
|
||||
|
The easiest way to do this, is to minimize the window, right click on it, and click on "view code". (You can also get there by double clicking "This workbook" in your VB editor)
You are then in the auto macro section  Then, just use the auto_open function to run your macro, e.g. Code:
Private Sub Workbook_Open() Module1.Macro1 End Sub This will automatically run Macro1, which is stored in Module1. Alternatively, you can just copy and past your code into the function. Hope this makes sense, otherwise let me know, and I'll try to explain a bit better
|
|
#4
July 21st, 2003, 02:53 AM
|
||||
|
||||
|
It's a pleasure. I also forgot how to do this. When I needed it (about a week ago), I had to search throught the help files for half an hour before I stumbled on it (only by luck). I think your way of finding the answer was way better
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Macro |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
thank1
Linear Mode
