Linked file version disabled macro buttons

[Shane]

Hello,

I'm using Excel 2007. I've saved an updated version of a file over the
old version of the file. Somehow the old and new version are now
linked. If I try and run a macro I'm told that it is not available or
that the macros are disabled. (The macros are enabled) At this point
the linked file is opened. If I break the links between the two files
then the macro buttons are disabled and I can't get them back. What am
I doing wrong? Seems so simple.

 

[Dave Peterson]

Try reassigning the macro to the button (or object) that starts your macro.

 

[Shane]

Thanks Dave.

I reassigned the names and all is fine.

However, each time I email the spreadsheet the same thing happens. I
can't be reassigning each time. What can I do to 'lock' the workbook
so that I don't lose my assignments?

Thanks.

 

[Dave Peterson]

Depending on where those buttons are, you have a couple of different options.

If you built a custom toolbar, then I'd replace it with a routine that builds
the toolbar when the workbook opened.

If you used a button from the Forms toolbar, then I'd replace it with a
commandbutton from the control toolbox toolbar.

Or maybe write code that changes the .onaction to point at the correct macro.

Hard to know what you're doing...