Solutions to the macro content in Excel that doesn't display correctly

Earlier we learned how to use macro table functions to make catalogs, and how to use the Hyperlink function to configure links for the directory.

Can be reopened, the related macro-table function is not the spirit ...

Because the macro table function get. Workbook (1) works through macro functionality, so the document must be saved in the Excel-enabled Workbook (*.xlsm) format so that the worksheet directory will be displayed correctly the next time you open it.

Click the Save button in the upper-left corner of Excel.

Excel prompts you not to save the following features in a macro-enabled workbook, click No to continue.

Select theExcel macro-Enabled Workbook (*.xlsm)file format from the Save as type drop-down box, and then save.

Files in *.xlsm format.

In addition, Excel disables macros by default when you open the workbook, and you have to click the Enable Content button in the warning bar to display the worksheet directory.

Open the Excel table Prompt "contains a macro that cannot be disabled in this workbook"

Failure phenomenon:
To open an Excel table tip error message:
The workbook contains a pet that cannot be disabled and cannot be signed (Microsoft Excel 4.0 version of the macro). Therefore, the workbook cannot be opened under high security. If you want to open this workbook, click Macros on the Tools menu, click Security, and then click Medium in the Security dialog box.
Reason Analysis:

Microsoft office--"macro virus" on your computer.

Solution:

1. Delete Book1 files under C:/Program files/microsoft Office/office11/xlstart, delete c:/documents and settings/administrator/ Application the macro file in Data/microsoft/excel/xlstart.
2, download "Macro virus Kill tool" for the overall killing, download address: http://bbs.duba.net/ Thread-22450603-1-1.html (Cleanmacro) is an amateur work by the senior anti-virus engineer of the poison fighter to solve Book1, Startup, Results, Poppy, Copymod, Blackice , Yugall, and other office-common macro viruses.
3, in order to prevent virus infection again, you can set the macro security to the highest: tools-options-security-macro security-security level.