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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks