Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've been searching for hours, can't find a solution but it's probably
simple...how can I tell what sheet was the ActiveSheet BEFORE they changed to the current activesheet. Example: User is on a particular sheet (let's say they're on "Main"), then they click the tab to go to the "Prices" sheet. How can I tell what sheet they're comming FROM - in this case the "Main" sheet? In the Workbook and the Worksheet events Activate and Deactivate, I check the Sheet parameter (SH) and it always shows "Prices", the sheet they're going too. Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
do some code after the sheet name is changed | Excel Discussion (Misc queries) | |||
Select the ActiveSheet & the sheet next to it | Excel Discussion (Misc queries) | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
My ActiveX control does not respond when i draw it on a excell sheet, using ActiveSheet.OLEObject.Add | Excel Programming | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming |