Linked file version disabled macro buttons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shane - 22 Jan 2008 17:40 GMT

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.

Reply to this Message

Dave Peterson - 22 Jan 2008 18:29 GMT

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

> Hello,
>
[quoted text clipped - 5 lines]
> then the macro buttons are disabled and I can't get them back. What am
> I doing wrong? Seems so simple.

Signature

Dave Peterson

Reply to this Message

Shane - 29 Jan 2008 16:28 GMT

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.

> Try reassigning the macro to the button (or object) that starts your macro.
>
[quoted text clipped - 11 lines]
>
> Dave Peterson

Reply to this Message

Dave Peterson - 29 Jan 2008 16:41 GMT

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...

> Thanks Dave.
>
[quoted text clipped - 21 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message