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
|