run a macro when i open a worksheet

rcamr · May 10th, 2002, 10:05 PM

please can someone tell me how i can run a macro as soon as a worksheet is opened Not Workbook)

Tom Schreiner · May 10th, 2002, 10:07 PM

You can place the name of your macro in the worksheet's activate event.



Private Sub Worksheet_Activate()

YourMacroNameHere

End Sub

Tom

rcamr · May 10th, 2002, 10:18 PM

sorry tom it doesnt seem to work
can you explain in further detail
Thanks

Nimrod · May 10th, 2002, 10:42 PM

-1 rt click on sheet tab
-2 select view code
-3 see left vb project window in vb editor
-4 double click on sheet objects (i.e. sheet1)
-5 Paste code into each sheet object
-6 done

Tom Schreiner · May 10th, 2002, 10:49 PM

Paste your code...
When the sheet is activated, your code should run.
Tom

May 10th, 2002, 10:07 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	You can place the name of your macro in the worksheet's activate event. Private Sub Worksheet_Activate() YourMacroNameHere End Sub Tom

May 10th, 2002, 10:42 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	-1 rt click on sheet tab -2 select view code -3 see left vb project window in vb editor -4 double click on sheet objects (i.e. sheet1) -5 Paste code into each sheet object -6 done __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 10:05 PM	#1
rcamr New Member Join Date: May 2002 Posts: 21	please can someone tell me how i can run a macro as soon as a worksheet is opened Not Workbook)

May 10th, 2002, 10:18 PM	#3
rcamr New Member Join Date: May 2002 Posts: 21	sorry tom it doesnt seem to work can you explain in further detail Thanks

May 10th, 2002, 10:49 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Paste your code... When the sheet is activated, your code should run. Tom