Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro accessible to 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. this is the macro: Sub Menu() ' ' Menu Macro ' Macro recorded 8/21/2008 by Goodyear ' ' Keyboard Shortcut: Ctrl+m ' Sheets("MENU").Select End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro accessible to all users
1. When you add an item to the menu bar, Excel saves that in your
Excelxx.xlb file. This file is not available to other users. 2. Create the menu item from code in the workbook, which stays with the workbook. To get an idea of the how-to for that see Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Fri, 29 Aug 2008 10:32:00 -0700, 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. this is the macro: Sub Menu() ' ' Menu Macro ' Macro recorded 8/21/2008 by Goodyear ' ' Keyboard Shortcut: Ctrl+m ' Sheets("MENU").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make sure my Wkbook is accessible to users using earlier | Excel Discussion (Misc queries) | |||
Macro works for some users and not others | Excel Discussion (Misc queries) | |||
Password a Macro so certain users can press it | Excel Discussion (Misc queries) | |||
How can I disable macro security for all users at once? | Excel Discussion (Misc queries) | |||
macro works for some users and doesn't for others | Excel Discussion (Misc queries) |