Having issue with macro enabled sheet

The error 'Run time error 3004' typically indicates that there is an issue with the macro or the environment in which it is running. Here are some steps you can take to troubleshoot and resolve this issue:

1. Check Macro Settings: Ensure that macros are enabled in your Excel settings. You can refer to the article on how to enable or disable macros in Office files to verify this.
2. Review the Macro Code: If you have access to the macro code, check for any syntax errors or issues that might be causing the runtime error.
3. Compatibility Issues: Ensure that the macro-enabled sheet is compatible with your version of Excel. Sometimes, macros created in newer versions may not work properly in older versions.
4. Security Restrictions: If the macro attempts to access external resources or files, security settings may prevent it from running. Check your security settings and adjust them if necessary.
5. Repair Office: If the issue persists, consider repairing your Office installation. This can fix any underlying issues that may be causing the error.

If these steps do not resolve the issue, consider reaching out to Microsoft Technical Support for further assistance.

References:

• This document was opened with macros disabled
• Unexpected error; please contact Microsoft Technical Support