Hi:

I am trying to define two global variables, thus:

Public wbpath As String
Public timesheet As String

My problem is that this set of commands isn't executing. I set the values in auto_open
macro, and these two commands are right before the auto_open macro, but the value of
wbpath isnt recognized by subsequent macros.

Where should I put them to ensure that they execute at startup of the spreadsheet?

Thanks

John Baker