Excel runtime error 1004 vba

What is Excel runtime error 1004 vba?

Excel runtime error 1004 vba is an error that usually occurs when a macro is not configured correctly or it has a conflict with another sheet.

 

How can you fix Excel runtime error 1004 vba?

Some of the solutions to this error include saving the Excel file using the correct file extension.

 

Please see our in-depth walk-through solutions below.

Sheila Staff Asked on August 7, 2017 in Microsoft Excel.
Add Comment
4 Solution(s)

Solution 1. Save Excel file to .xlt ( 2003 and lower) or *.xltx (2007 and higher)

“Excel runtime error 1004 VBA” may appear when your using a macro but did not enable it when saving. Please see below to fix the error, how to save a macro enabled excel file. The error may also occur when you call or use an Excel file in your Visual Basic for application (VBA) program code while the excel file has two or mode sheet, it may be caused a conflict. Please delete unwanted sheet.

  1. Create a new workbook.

    RE: Error 1004

  2. Delete all sheets except for sheet you are working on by right-clicking the sheet and then selecting Delete.
  3. Input data in the Workbook.
  4. Click File tab, and then click Save As.
  5. In the Save as type list, click Template.
  6. Then type in the filename and then click Save. You may input a file extension to make sure it is saved as a Template.
    NOTE: .xlt ( 2003 and lower) or .xltx (2007 and higher)
  7. Copy a macro and paste it.
Gino Genesis Marasigan Staff Answered on August 13, 2017.
Add Comment

Solution 2. Enable Trust access to the VBA project object model

Excel runtime error 1004 VBA might be caused by a disable Trust access to the VBA project object model. You may want to enable it. See instructions below to enable it.

  1. Open MS Excel and then click File >> Option.

    RE: Excel runtime error 1004 vba

  2. Then click Trust Center >> Trust Center Settings >> Marco Settings.
  3. Check the checkbox of “Trust access to the VBA project object model” and then click Ok.
Gino Genesis Marasigan Staff Answered on January 15, 2018.
Add Comment

Solution 3. Uninstall Microsoft work

Excel runtime error 1004 VBA could be caused by a conflict between your Microsoft Office and your Microsoft Works. If you have installed this both, you may want to uninstall Microsoft Works.

  1. Go to Control panel.

    RE: Excel runtime error 1004 vba

  2. Look for Microsoft Works.
  3. Right-click Microsoft Works and select Uninstall.
Gino Genesis Marasigan Staff Answered on January 15, 2018.
Add Comment

Solution 4. Disk Cleanup

The error Excel runtime error 1004 VBA could be caused by temporary files and cache. You may want to run the Disk Cleanup to delete all cache and temporary files related to your MS excel.

  1. Run Disk clean up, click Windows start then type in “Disk Cleanup” and then press Enter key.

    RE: Excel runtime error 1004 vba

  2. Click all checkbox, click Ok button and press Ok for the confirmation.
  3. Restart or proceed below.
Gino Genesis Marasigan Staff Answered on January 22, 2018.
Add Comment

Your Solution

By posting your solution, you agree to the privacy policy and terms of service.