Brian Hearty via OfficeKB.com
Guest
Open Workbook At A Set Page
There is a web site called www.officearticles.com that explains some good
tips on using excel. However, I am having difficulties getting one of the
tips to work.
To ensure that a workbook is opened at a specific page regardless of where
the last user was within the book when he/she saved and closed it the
following piece of VB code is suggested:
While in Visual Basic Editor, double-click ThisWorkbook and enter the
following code:
Private Sub Workbook_Open()
Range("Sheet1!A1").Activate
End Sub
Unfortunately I get a run time error each time I attempt to run it - is there
something extra that needs to be included in the code in order for it to run
correctly?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1
Bookmarks