|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
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 2nd, 2003, 03:24 AM
|
|||
|
|||
|
vb and excel
Could someone tell me how I can set up a vb macro to run in excel when you open the spreadsheet.
I have a navigation form for the spreadsheet and I want it to be the first thing that is viewed when the user opens the spreadsheet. Cheers
|
|
#2
July 2nd, 2003, 08:22 AM
|
||||
|
||||
|
Open the vba editor (Alt + F11) and double-click on the ThisWorkbook object in the project list. In the code window that opens click on the first dropdown that has "(General)" in it and click on "Workbook", this should open and create a sub called Private Sub Workbook_Open()
load and show your form from this sub. Also, in the future please use an appropriate subject title. You can refer to the sticky thread at the top of this forum on how to post a question for more information.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Show a form on startup in excel(use to be:vb and excel) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
