Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to activate a worksheet when a macro is running in the sheet m
Problem:
I want to move to cell A1 (sheet 1) when a certain nr occurs in cell B1, for ex 1. Cell B1 contains a formula that refers to a cell in sheet 2. My problem is that this doesn´t happen until I do anything in sheet 1 like use one arrow or klick with the mouse in a cell. How can I activate sheet 1 within the macro below? The macro looks like this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Range("B1") Case Is = 1 "The macro feel nr 1 but do not execute until anything Range("A1").Select happens in sheet 1" End Select Hope for a swift answer BFSWE End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet- activate macro | Excel Discussion (Misc queries) | |||
Prevent code in "Sheet Activate" from running when sheet made visible from other macr | Excel Programming | |||
Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
Activate Macro on Activating a sheet | Excel Programming | |||
Run Macro on Worksheet Activate | Excel Programming |