How to action on Open Sheet
 

I would like to know how to do certain action when particular sheet opens.
Let say I have 5 sheets in one spreadsheet and I want to sort only one sheet
name "Test" on open.

Thanks for your help

Jan

How to action on Open Sheet
 

Hi Jan

do you mean when the workbook first opens - place your code in the
Workbook_Open
event (in the "ThisWorkbook" module)
if you mean when a sheet is activated - use the
Worksheet_Activate
event (in the module of the sheet that you want the event to apply to)

Hope this helps
Cheers
JulieD

"Jan Nademlejnsky" wrote in message
...
I would like to know how to do certain action when particular sheet opens.
Let say I have 5 sheets in one spreadsheet and I want to sort only one
sheet name "Test" on open.

Thanks for your help

Jan