View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 99
Default sheet specific desktop shortcut

Hi,

macros example: put on Thisworkbook of your file

Private Sub Workbook_Open()
Select Case Application.UserName
Case "isabelle": Sheets(4).Activate
Case "blabla1": Sheets(2).Activate
Case "blabla2": Sheets(1).Activate
Case "blabla3": Sheets(3).Activate
End Select
End Sub

Otherwise, would can do a référence table for users names

isabelle

Le 2016-11-24 Ã* 15:33, Paul Doucette a écrit :
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.

Thanks!!