LTL1963
New Member
- Joined
- Dec 10, 2004
- Messages
- 31
I need to change the GoTo macro linked to a toolbar destination name from "RE1" to "ReimbursableExpenses_1". If I do that in the VBA, it does not work in the toolbar, goes in to Debug. Do I have to reassign the macro to the toolbar and if so how?
One of the reasons I have to do this is I am working in Excel 2003, 2007, 2010 & Mac 2011. MS Office 2011 sees the "RE1" reference as a cell and goes to debug mode when the files opens, I corrected it in 2011 to their recommendation "RE_1" and it worked, but then it didn't work in the other 3 versions.
Sub Goto_RE1()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE1"
Range("V348").Select
End Sub
Sub Goto_RE2()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE2"
Range("V408").Select
End Sub
Sub Goto_RE3()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE3"
Range("V468").Select
End Sub
I'm sure there will be more issues between PC and MAC versions, but one at a time.
Thanks in advance for any help.
One of the reasons I have to do this is I am working in Excel 2003, 2007, 2010 & Mac 2011. MS Office 2011 sees the "RE1" reference as a cell and goes to debug mode when the files opens, I corrected it in 2011 to their recommendation "RE_1" and it worked, but then it didn't work in the other 3 versions.
Sub Goto_RE1()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE1"
Range("V348").Select
End Sub
Sub Goto_RE2()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE2"
Range("V408").Select
End Sub
Sub Goto_RE3()
'
' w Macro
' Macro recorded 12/20/2005
'
'
Application.Goto Reference:="RE3"
Range("V468").Select
End Sub
I'm sure there will be more issues between PC and MAC versions, but one at a time.
Thanks in advance for any help.