=> How to setup vars when a workbookopen event is launched?

[Guest]

I need to setup some variables in my VBA code before the program starts. I
think one could to include this setup in the Workbook_Open event, before the
worksheet be loaded. How Can I do this? Second: does VBA support "Typed
Constants" like Delphi or C? For example I would like to initialize a global
(public) boolean var called FirstTime as True, so when the first macro code
starts running it has this True value by default.

 

[Bob Phillips]

Create this variable in a standard code module

Public FirstTime As Boolean

In the Thisworkbook class modujle add

Private Sub Workbook_Open()
FirstTime = True
End Sub