sheet specific desktop shortcut
Hi Pual,
Am Thu, 24 Nov 2016 12:33:06 -0800 (PST) schrieb Paul Doucette:
G\Is it possible to have a desktop shortcut open an excel file and go to a specific worksheet, even if the file was saved with a different sheet selected?
I have a workbook with about 20 worksheets, and four users. I would like it to open to a different sheet for each user.
in a standard module:
Sub UsersSheet()
Dim shN As String
Select Case Application.UserName
Case "Name1"
shN = "Sheet1"
Case "Name2"
shN = "Sheet2"
Case "Name2"
shN = "Sheet3"
|