Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got a workbook with several different sheets. I want a macro
that will select the required sheet depending on what cell is highlighted. For example there are cells for Jan, through to Dec. If the Mar cell is highlighted, when the user clicks on the macro button I want it to open the sheet for Mar and do some processing. I know how to do the processing but how do you change what sheet is active based on this kind of user action? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
activesheet | Excel Programming | |||
Get ActiveSheet name in VB | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming |