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?


--
renderingsanity
------------------------------------------------------------------------
renderingsanity's Profile: http://www.excelforum.com/member.php...o&userid=32931
View this thread: http://www.excelforum.com/showthread...hreadid=527548

Opening a workbook to a chosen sheet?
 

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

Sheets(Application.UserName).Select

--
Don Guillett
SalesAid Software

"renderingsanity"
<renderingsanity.25fmhz_1143637204.8169@excelfor um-nospam.com wrote in
message news:renderingsanity.25fmhz_1143637204.8169@excelf orum-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