View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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"