| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick and Easy!
What is the proper 'Sub' - 'End Sub' Syntax to make some VBA run when the
Excel file is first opened? Workbook_Open() something or other???? DBAL Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick and Easy!
Private Sub Workbook_Open()
End Sub Pasted in the ThisWorkbook Object in the VBE Right Click on Excel Icon in the upper left of the Excel Window and choose View Code. Paste this code. HTH "DBAL" wrote: What is the proper 'Sub' - 'End Sub' Syntax to make some VBA run when the Excel file is first opened? Workbook_Open() something or other???? DBAL Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick and Easy!
Ahh man, so that's the problem, I had the right code, but I guess it was in
the wrong place! So the workbook code is kept in a different spot then... Thanks! "Jim Thomlinson" wrote: Private Sub Workbook_Open() End Sub Pasted in the ThisWorkbook Object in the VBE Right Click on Excel Icon in the upper left of the Excel Window and choose View Code. Paste this code. HTH "DBAL" wrote: What is the proper 'Sub' - 'End Sub' Syntax to make some VBA run when the Excel file is first opened? Workbook_Open() something or other???? DBAL Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick and Easy!
you can also use
Sub Auto_Open() ' your code End SUb in a standard module "DBAL" wrote: What is the proper 'Sub' - 'End Sub' Syntax to make some VBA run when the Excel file is first opened? Workbook_Open() something or other???? DBAL Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for a easy and quick way to share a workbook only with mys | Excel Discussion (Misc queries) | |||
| Quick/Easy Question? | Excel Discussion (Misc queries) | |||
| is there a quick easy way to input time? | Excel Worksheet Functions | |||
| Quick and easy labeling | Excel Discussion (Misc queries) | |||
| Quick and easy | Excel Worksheet Functions | |||
![DBAL[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
