Macro not running when selected

Question

Hello,

After being out on vacation and returning. I tried to use one of my Excel files and the Macro that I have on one of the pages as a button is no longer working and is giving me the following error. Any help would be appreciated.

Answer 1

Show us the file.

If the file contains confidential data: Make a copy of the file, open the copy and delete the confidential data.

IMPORTANT: Zip your file!
https://support.microsoft.com/en-us/windows/zip-and-unzip-files-8d28fa72-f2f9-712f-67df-f80cf89fd4e5

Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).
Click Upload in the top and choose your file.
After uploading, right click the file and choose Share.
Click Copy Link in the lower left edge (no need to enter an email).
Copy the link and paste it here.

Andreas.

Answer 2

Ossie,

The workbook with the button and the one containing the macro is one in the same. I was able to open up Visual Basics for Applications - Proposal Template - BLANK.xlsm and run the macro from within it. But I'm still unable to run the Macro directly from the workbook.

Answer 3

The file I have open is in fact "Proposal Template - BLANK.xlsm" how do I do as you suggested and redirect the button to the local macro?

I was able to open up Visual Basics for Applications - Proposal Template - BLANK.xlsm and run the macro from within it.

Answer 4

It is possible that during your absence someone moved the workbook containing the macro to another folder or renamed the called macro. You could check if both workbooks are in the same folder and check the sub name.

Alternatively:

• Open both workbooks (The workbook with the button to call the macro and the workbook containing the called macro)
• Select the workbook containing the button to call the macro.
• Right click the button that calls the macro
• Select Assign macro
• In the dialog, select the required macro to be called and click OK.
• Save the workbook containing the macro and close it.
• Save the workbook with the button.
• Click the button and test.

Answer 5

That means the macro named "Final" is inside the file named "Proposal Template - BLANK.xlsm" and Excel can not open that file to execute it.

If you have the macro in your actual file too, redirect the button to your local macro.

Andreas.