Opening a workbook to a chosen sheet?

Hello everyone! I'm so thankful I found this forum! I just started really working with excel at my job and my group leader wants to be able to have everyone recieve just their worksheet(a list of stores each of us works with)

The original file is a workbook with about a dozen worksheets, each with one of our names. I put a shortcut from her workfolder to all of ours to get us through for the time being but ideally she wants to update her file and have it update everyones single spreadsheet in their folders.

If that's not possible, being able to add some kind of switch to the end of the shortcut to choose one sheet to default to would be the second option.

Is any of this possible?

Put this line in your workbook_open event in the ThisWorkbook module.
Be SURE they match

Sheets(Application.UserName).Select

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"renderingsanity"
<renderingsanity.25fmhz_1143637204.8169@excelforum-nospam.com> wrote in
message news:renderingsanity.25fmhz_1143637204.8169@excelforum-nospam.com...
>
> Hello everyone! I'm so thankful I found this forum! I just started
> really working with excel at my job and my group leader wants to be
> able to have everyone recieve just their worksheet(a list of stores
> each of us works with)
>
> The original file is a workbook with about a dozen worksheets, each
> with one of our names. I put a shortcut from her workfolder to all of
> ours to get us through for the time being but ideally she wants to
> update her file and have it update everyones single spreadsheet in
> their folders.
>
> If that's not possible, being able to add some kind of switch to the
> end of the shortcut to choose one sheet to default to would be the
> second option.
>
> Is any of this possible?
>
>
> --
> renderingsanity
> ------------------------------------------------------------------------
> renderingsanity's Profile:
> http://www.excelforum.com/member.php...o&userid=32931
> View this thread: http://www.excelforum.com/showthread...hreadid=527548
>