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.

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.

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.