View Single Post
 
Old 06-27-2012, 07:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The 'default page' is whatever was on screen when the workbook was last saved. If you need something else, you'll need a Workbook_Open macro in the workbook's 'ThisWorkbook' module that automatically switches to the required worksheet & range when the workbook is opened. For example:
Code:
Private Sub Workbook_Open()
  ThisWorkbook.Sheets("SomeSheet").Activate
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote