Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
why, when i open a work sheet does a blank sheet open as well | Excel Discussion (Misc queries) | |||
Copy Sheet action very slow | Excel Discussion (Misc queries) | |||
How to insert Open File action in the IF Function? | Excel Discussion (Misc queries) |