View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

It sounds like you're assigning the macro to a button/object/icon on a toolbar.

If that's the case, you may want to reassign the macro in code to the workbook
that owns the macro.

If you used a button from the Forms toolbar, a simple change may work for you.

Delete that button and use a commandbutton from the control toolbox toolbar.

Then double click on that commandbutton and have that code call your macro:

Option Explicit
Private Sub CommandButton1_Click()
Call myExistingMacro
End Sub


If you have trouble, you may want to post back with more details.

SpeclAngel wrote:

I am trying to keep a macro with a workbook when I move it from my laptop to
my desk computer. I have to redirect the macro everytime I move the workbook


--

Dave Peterson