How to action on Open Sheet

[Jan Nademlejnsky]

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

 

[JulieD]

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