Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autorun code when opening sheet (not workbook)
H
I have a code that I want to use... but automaticalled when one enters a sheet. How do i do this For instanc If i click on "sheet2 Sheet 2 opens u I want it so that If i click on sheet2 (open sheet2 that a code of my choosing will automatically run for that sheet Thanks Steve Mutambo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autorun code when opening sheet (not workbook)
Steve,
Use the Activate event of the worksheet. Right click on the sheet tab and choose View Code. In the code module that opens up, use Private Sub Worksheet_Activate() ' your code here End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Steve Mutambo" wrote in message ... Hi I have a code that I want to use... but automaticalled when one enters a sheet. How do i do this? For instance If i click on "sheet2" Sheet 2 opens up I want it so that If i click on sheet2 (open sheet2) that a code of my choosing will automatically run for that sheet. Thanks, Steve Mutambo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
autorun code when opening sheet (not workbook)
Steve,
you need to put your code in the Activate event of the worksheet. To do this from the VBE, double click on the relevant sheet in the Project Explorer window, select "Worksheet" from the first dropdown and "Activate" from the second. Insert the required code. Cheers, Pete. -----Original Message----- Hi I have a code that I want to use... but automaticalled when one enters a sheet. How do i do this? For instance If i click on "sheet2" Sheet 2 opens up I want it so that If i click on sheet2 (open sheet2) that a code of my choosing will automatically run for that sheet. Thanks, Steve Mutambo . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
autorun code when opening sheet (not workbook)
You the man Chi
You the man Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
Executing code with opening target workbook | Excel Programming | |||
Performing code without opening the Workbook | Excel Programming | |||
Code for Opening a Closed Workbook | Excel Programming | |||
Autorun macro on opening spreadsheet | Excel Programming |