Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109679
| From | isabelle <i@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: sheet specific desktop shortcut |
| Date | 2016-11-25 01:44 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <o18mkm$vle$1@gioia.aioe.org> (permalink) |
| References | <f17942ac-2d21-436e-b0b2-c46e5c0f29b0@googlegroups.com> |
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!! >
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
sheet specific desktop shortcut Paul Doucette <pauld@mewood.com> - 2016-11-24 12:33 -0800 Re: sheet specific desktop shortcut Claus Busch <claus_busch@t-online.de> - 2016-11-25 07:36 +0100 Re: sheet specific desktop shortcut isabelle <i@v.invalid> - 2016-11-25 01:44 -0500 Re: sheet specific desktop shortcut aloinam109 <aloinam109@gmail.com> - 2016-11-25 14:02 +0000 Re: sheet specific desktop shortcut Paul Doucette <pauld@mewood.com> - 2016-11-25 09:44 -0800
csiph-web