How can I activate cell A1 each time I switch to another she

andy-s · Apr 24th, 2002, 03:02 PM

Tjobings...

QUESTION 1
I wonder if there is a way, either by macro or predefined excel command, to activate cell A1 each time I change to another sheet.

QUESTION 2
I've about 25 macros defined in 14 Modules. Should I use only 1 Module wiht alle the 24 macro definition, or doesnt it affect the Excel performance at all?

Thanks...

lenze · Apr 24th, 2002, 03:04 PM

Place this code in the WorkSheet Modules

Private Sub Worksheet_Activate()
Range("$A$1").Select
End Sub

[ This Message was edited by: lenze on 2002-04-24 14:05 ]

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

Apr 24th, 2002, 03:02 PM	#1
andy-s Board Regular Join Date: Mar 2002 Posts: 51	Tjobings... QUESTION 1 I wonder if there is a way, either by macro or predefined excel command, to activate cell A1 each time I change to another sheet. QUESTION 2 I've about 25 macros defined in 14 Modules. Should I use only 1 Module wiht alle the 24 macro definition, or doesnt it affect the Excel performance at all? Thanks...

Apr 24th, 2002, 03:04 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Place this code in the WorkSheet Modules Private Sub Worksheet_Activate() Range("$A$1").Select End Sub [ This Message was edited by: lenze on 2002-04-24 14:05 ]