Where would you write an "Open Workbook sub"?

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

Okay, so I just know enough VBA programing to make me sound dum
compared to you guys. But where exactly could I write some simpl
parameters for my workbook to use each time I open it
 
Hi
two ways:
1. Use the workbook open event:
- open the VBA editor
- double click in the explorer window of the VBA editor on
'ThisWorkbook'
- insert the code for the Workbook_open event

2. Name your procedure Auto_Open
 
You can write data to any of the worksheets within the workbook, such as

Worksheets(1).Range("A1").Value = "parameter 1"

You could keep the sheet that you store this data on as a hidden sheet
within the workbook so as not to confuse.



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top