Private Sub Workbook_Open()

[fulltime]

Hi all,

When i put my codes in the following sub, Private Sub Workbook_Open() , into my spreadsheet, the codes in this sub will be executed whenever this worksheet is loaded. However, I need to pass in an argument into this sub, isit possible to be done?

Thks
FT

 

[HaHoBe]

Hi, fulltime,

if you mean the workbook it´s: yes. If you really mean the worksheet you should make good use of the Workbook_SheetActivate(ByVal Sh As Object) event.

What about an inputbox in the code?

Ciao,
Holger

 

[fulltime]

Hi, fulltime,

if you mean the workbook it´s: yes. If you really mean the worksheet you should make good use of the Workbook_SheetActivate(ByVal Sh As Object) event.

What about an inputbox in the code?

Ciao,
Holger

got it, thks