Need help with Excel VB

[programmernovice]

Hi, is there some macro command in Excel VB with is triggered when a
given worksheet is opened? If so what's the syntax? Many thanks in
advance.

 

[Damon Longworth]

There is a workbook open event in which any code can be triggered when the
workbook is opened.

Right click on the Excel icon next to the File menu - View code - Select
Workbook in the drop down menu containing General.

--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html

Hi, is there some macro command in Excel VB with is triggered when a
given worksheet is opened? If so what's the syntax? Many thanks in
advance.

 

[Per Erik Midtrød]

Yes there is and it is called an event.
Right-click the sheet, select view code and insert something like:

Private Sub Worksheet_Activate()
MsgBox ("Hello world")
End Sub

Per Erik

 

[Tom Ogilvy]

Just some supplementary information:
A useful overview of events is available at Chip Pearon's site:

http://www.cpearson.com/excel/events.htm
and application level events
http://www.cpearson.com/excel/appevent.htm

 

[Gord Dibben]

Private Sub Worksheet_Activate()
'do your stuff
End Sub


Gord Dibben MS Excel MVP

 

[programmernovice]

Just some supplementary information:
A useful overview of events is available at Chip Pearon's site:

http://www.cpearson.com/excel/events.htm
and application level eventshttp://www.cpearson.com/excel/appevent.htm

--
Regards,
Tom Ogilvy









- Show quoted text -

Many thanks to you and everyone else who replied. Very useful stuff.