This message appears when you have made changes to a macro in the Visual Basic Editor and have also changed the copy of your workbook in the Microsoft Script Editor.
To save the changes to your macro, do the following:
- Click No.
- Switch to the Visual Basic Editor window.
- Export any modules you have changed.
- In your workbook in Microsoft Script Editor, click Refresh
on the Refresh toolbar. - Click Yes.
- Import the modules to restore the changes to your macro.
While recording a macro, I recorded an action I didn't want.
To undo an unwanted action in a macro, you can open the macro in the Visual Basic Editor and remove any unwanted steps.
If you don't want to use the Visual Basic Editor, record the macro again without the unwanted action.
A macro I recorded sometimes produces an error message.
A macro you record may not run properly in every situation. If the macro cannot run, Microsoft Excel displays an error message. Some macros depend on certain options or settings in Excel. For example, a macro that searches for bold text won't run properly if bold text isn't displayed. If a macro you've recorded produces an error message, note the error number. You can then search for "error messages" in Visual Basic Help and find information about the message you received.