VB Code - easy if you know how!

[LeeHitchen]

Can anyone pse tell me where to place VB code to ensure it is actioned whenever I open the spreadsheet (ie condition is active all the time)as opposed to placing the VB within a macro environment and having to run it each time I open said sheet.

Many thanks

Lee

 

[dantb]

This should start it when the workbook is opened. Hope it helps Dan

Private Sub Workbook_Open()
""VBA Code Here""
End Sub

 

[LeeHitchen]

Just the ticket, many thanks dantb

 

[dantb]

Anytime, Learning myself good luck !

 

[eliW]

On 2002-04-18 11:01, LeeHitchen wrote:
Can anyone pse tell me where to place VB code to ensure it is actioned whenever I open the spreadsheet (ie condition is active all the time)as opposed to placing the VB within a macro environment and having to run it each time I open said sheet.

Many thanks

Lee

Lee,
Look at this:
http://www.mrexcel.com/board/viewtopic.php?topic=5542&forum=2&4
Especially Mark O'Brien's answer
Eli

 

[LeeHitchen]

Thanks Eli, it's all starting to make sense at long last!

Regards

Lee