change active cell when clicking a tab

jabba9

New Member
Joined
May 18, 2004
Messages
42
i need to the active cell to change to A1 when the user clicks on a worksheet (tab)

any help?

thanks

Mike
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

jabba9

New Member
Joined
May 18, 2004
Messages
42
i think i understand the concept, but it's not working

i have other macros in the workbook, and added your code to the bottom, but no luck

Mike
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Hello Mike,
bandit's code needs to go in the worksheet module(s) for the sheet(s) of interest.
Right click the sheet tab and choose View code. Paste bandit's code in the white area that is the sheet code module.
Press AltQ to get back to your sheet. (Repeat for any other sheets you want this to work on.) If you have a "boatload" of sheets and want to assign this to every sheet in the workbook, you can do it in the ThisWorkbook module.
That code would look like:
Code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("A1").Activate
End Sub
Hope it helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,269
Messages
5,577,108
Members
412,768
Latest member
klig
Top