Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
opening pages
when opening a page in a workbook, is thier a wat get it to default to cell
a1 , ??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
opening pages
Hi Rich,
Try: '============= Private Sub Workbook_SheetActivate(ByVal Sh As Object) Sh.Range("A1").Select End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module): Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman "Rich" wrote in message ... when opening a page in a workbook, is thier a wat get it to default to cell a1 , ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbering pages | Excel Worksheet Functions | |||
numbering all pages in worksheet | Excel Discussion (Misc queries) | |||
How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) |