Solved: call a macro from within another macro works then doesn't

[yorkie]

Hi there,

I'm using a button to run a macro. However what i'd like to do is have a message pop up when the mouse rolls over the button then when the button is clicked it moves to another sheet.
The following shows the popup message



Sub MyMacro1()
Dim shp As Shape
Set shp = ActiveSheet.Shapes("Rectangle 1")
ActiveSheet.Hyperlinks.Add shp, "", "", ScreenTip:="Click button to move to Bank details"
Call MyMacroA
End Sub




Is should call MyMacroA and move to another sheet/range using the following code


Sub MyMacroA()
Sheets("Sheet2").Select
Range("A4").Select

End Sub




However sometimes this works sometimes it doesn't. For the life of me i can't see wha the problems is.
Has anybody got any tips or ideas?
Using Office 2010, on vista and windows 7
Am i asking excel to do too much or does anybody have a simpler way of doing this?
Many thanks in advance

[Trebor76]

Hi yorkie,

Try this:


Option Explicit
Sub Macro2()
'http://www.vbaexpress.com/forum/showthread.php?t=39640
Dim shp As Shape

With Sheets("Sheet1")
Set shp = .Shapes("Rectangle 1")
.Hyperlinks.Add _
Anchor:=shp, _
Address:="", _
SubAddress:="Sheet2!A4", _
ScreenTip:="Click button to move to Bank details"
End With

End Sub

HTH

Robert

[yorkie]

Thanks Robert that worked a treat - much appreciated.

[Trebor76]

You're welcome :)