Select the product you need help with
Why does macro contents in Excel display incorrectly? - EeeKBArticle ID: 2740211 - View products that this article applies to. Collapse this image 
(http://support.microsoft.com)
articleIn previous sections we have known about how to use macro sheet functions to build catalogs and how to use Hyperlink functions to configue links for catalogs. But when I reopen it, related macro sheet functions do not work anymore... Since the macro sheet function GET.WORKBOOK(1) works through macro features, the documentation must be saved as this format: Excel Macro-Enabled Workbook (*.xlsm), by which the sheet catalog could display correctly during the next opening. Click the "Save" button on the upper right-hand corner in the Excel. Collapse this image  A prompt "The following features cannot be saved in macro-free workbooks" will pop up in Excel. Please click "No" to continue. Collapse this image  Select "Excel Macro-Enabled Workbook (*.xlsm)" file format from the dropdown box "Save as type:", and save it. Collapse this image  Files in *.xlsm format. Collapse this image  In addition, when the workbook is opened, Excel will disable macros by default. The sheet catalog could display only when clicking "Enable Content" button. Collapse this image  If it does not work all the same, you are suggested to dig the Forum
(http://answers.microsoft.com/en-us/default.aspx)
for any great solutions.
|
Properties
Article ID: 2740211 - Last Review: February 8, 2013 - Revision: 3.0
Back to the top
