Hi,

Is there a method that, no matter where a user is in a workbook when
they save it, when it's next opened it will open on a specific sheet.

Thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=495135

Hi,

Try pasting something like this into the "ThisWorkbook" code window:
(Alt+F11 then doubleclick "ThisWorkbook")
This code will always run when the workbook is opened

Hope this helps & Happy Christmas!

Pete


Private Sub Workbook_Open()
Sheets("Sheet1").activate
Range("A1").select
End Sub

"mevetts" wrote:


Hi,

Is there a method that, no matter where a user is in a workbook when
they save it, when it's next opened it will open on a specific sheet.

Thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=495135

Genius, thanks.

Happy Christmas and New Year!

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=495135