Remove external path from macro assignments

Hey, I need to remove the external paths in my macro assignments. I only use shapes. (no active x/form controls)

I tried that, but it won't work for me:

http://www.ozgrid.com/forum/showthread.php?t=93459


example of an assignment: 'G:\10_excel\tool\show\PPI\update.xlam'!button_last12
=> should be button_last12 after i run the desired macro

Please help me

Thanks. I saw that I also had some form controls buttons. It worked for them, but not for the shapes

edit: I tried that, both won't work:

Sub wizardmaster()
ActiveSheet.Shapes("Last3_1 Inside").Select
Selection.OnAction = "button_last3"
End Sub

Sub test()
Worksheets("Tool").Shapes("Last3_1 Inside").OnAction = "wizardmaster"
End Sub => runtime 1004 here


I tried several onAction formulas now, neither of them worked. Maybe it's because I have codes in Option Explicit in the very beginning?

I got it working!

Please Login or Register  to view this content.

Could you please tell me how to assign those commands to all shapes on the sheet? (if not, I could also list them manually, it's around 10 shapes)

Thanks