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!!
|