What is the cause of EXCEL macro compilation error?

What is the compile error when running EXCEl macro

This is an error in the VBA code execution of the hidden program. Solution:

1) Press Alt F11 in Excel to open the macro editor;

2) Press Ctrl R in the macro editor to open the project resource management panel (if it is already open, nothing will change after pressing Ctrl R);

3) Find your file in the project resource management panel, click it, check whether "module n" exists (n is 1, 2...), right-click on these modules one by one, and "Remove module n" ".

4) Finally save it.

Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. In 1993, after version 5.0 was released as a component of Microsoft Office, Excel began to become the dominant spreadsheet software on applicable operating platforms.

Microsoft Office is a suite of office software developed by Microsoft. It can run on Microsoft Windows, Windows Phone, Mac series, iOS and Android systems. Like other office applications, it includes federated server and Internet-based services. Versions of Office from 2007 are called "Office System" rather than "Office Suite", reflecting the fact that they include servers.

There is a problem with the excel table macro command

When we use Word, the program provides an automatic save function by default, so that when unexpected situations occur, losses can be minimized. So can similar functions be provided for Excel? Take a look at how to do it in this article!

Have you ever thought about letting Excel automatically save files like Word to prevent accidental loss of work results? Then come with me!

Start Excel, then select the "Add-in" command under the "Tools" menu, select the check box in front of "Autosave" in the "Add-in" window that opens, and then click the "OK" button. Next, we will find the "Autosave" command under the "Tools" menu. Click to see the "Autosave" setting window. Not much to say here!

Here are several problems you may encounter during installation. Here are some solutions: 1. When installing the "Auto Save" macro, Excel may ask the user to insert the Office CD. 2. If there is no "Autosave" macro to choose from in the "Add-ins" window, please re-run the Office installer, select "Add and Remove Features", and expand the "Microsoft Excel for Windows→Add-ins→Autosave" item , select the "Run from this computer" button, and then follow the wizard.

It has the auto-save function itself. Just select "Tools → Options", then click the "Save" tab in the "Options" dialog box that opens, and select "Save automatic recovery information" in the "Save" tab. Select the box and set the corresponding time interval. Both Word 2000/XP and PowerPoint 2000/XP can automatically save documents through the "Tools → Options" command, select the "Save" tab in the "Options" dialog box, and then select the relevant auto-save options in the "Save" tab. .

The above is the detailed content of What is the cause of EXCEL macro compilation error?. For more information, please follow other related articles on the PHP Chinese website!