| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro accessible by all users
I have a workbook with a 'Switchboard' page with links to all of the
worksheets in the workbook. I have created a macro that takes me back to the Switchboard and added it to an icon on the menu bar. Every month I have to change the name of the workbook, which messes up the macro. Also, when someone else accesses the workbook from their computer, the macro doesn't work and the icon doesn't appear. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro accessible by all users
Post the macro. You should be usiing THISWORBOOK and not any references to
specific workbook names. "juliejg1" wrote: I have a workbook with a 'Switchboard' page with links to all of the worksheets in the workbook. I have created a macro that takes me back to the Switchboard and added it to an icon on the menu bar. Every month I have to change the name of the workbook, which messes up the macro. Also, when someone else accesses the workbook from their computer, the macro doesn't work and the icon doesn't appear. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro accessible by all users
this is the macro:
Sub Menu() ' ' Menu Macro ' Macro recorded 8/21/2008 by Goodyear ' ' Keyboard Shortcut: Ctrl+m ' Sheets("MENU").Select End Sub "Joel" wrote: Post the macro. You should be usiing THISWORBOOK and not any references to specific workbook names. "juliejg1" wrote: I have a workbook with a 'Switchboard' page with links to all of the worksheets in the workbook. I have created a macro that takes me back to the Switchboard and added it to an icon on the menu bar. Every month I have to change the name of the workbook, which messes up the macro. Also, when someone else accesses the workbook from their computer, the macro doesn't work and the icon doesn't appear. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro accessible to all users | Excel Discussion (Misc queries) | |||
| How do I make sure my Wkbook is accessible to users using earlier | Excel Discussion (Misc queries) | |||
| Macro runs OK for me, but not for the other users | Excel Programming | |||
| Macro works for some users and not others | Excel Discussion (Misc queries) | |||
| Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
Hybrid Mode
