Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make A1 the active cell in all visible worksheets ?
......so that when i activate the sheet A1 is the cell in the upper left corner of my screen.
Thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make A1 the active cell in all visible worksheets ?
in the dev environment (ALT+F11) open the project explorer (Ctrl+R), then right click the icon for ThisWorkbook and select View Code
add this code|: Option Explicit Private Sub Workbook_SheetActivate(ByVal Sh As Object) Range("A1").Select End Sub "Luc" wrote in message ... .....so that when i activate the sheet A1 is the cell in the upper left corner of my screen. Thanx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make A1 the active cell in all visible worksheets ?
Hi,
ALT+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code in on the right Private Sub Workbook_SheetActivate(ByVal Sh As Object) Application.Goto ActiveSheet.Range("A1"), scroll:=True End Sub Mike "Luc" wrote: ......so that when i activate the sheet A1 is the cell in the upper left corner of my screen. Thanx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make A1 the active cell in all visible worksheets ?
Patrick, Mike : Thanks for your help !!!!
Luc "Mike H" schreef in bericht ... Hi, ALT+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code in on the right Private Sub Workbook_SheetActivate(ByVal Sh As Object) Application.Goto ActiveSheet.Range("A1"), scroll:=True End Sub Mike "Luc" wrote: ......so that when i activate the sheet A1 is the cell in the upper left corner of my screen. Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value of active cell in other visible worksheets | Excel Programming | |||
Make the cell to be visible | Excel Programming | |||
Make a changing cell visible while still running | Excel Programming | |||
Checklist to make worksheets visible | Excel Programming | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) |