Thread: How to make A1 the active cell in all visible worksheets ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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
Reply With QuoteReply With Quote