Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Why does macro contents in Excel display incorrectly? - EeeKB

Why does macro contents in Excel display incorrectly? - EeeKB

View products that this article applies to.


In 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.





↑ Back to the top




A prompt "The following features cannot be saved in macro-free workbooks" will pop up in Excel. Please click "No" to continue.



Select "Excel Macro-Enabled Workbook (*.xlsm)" file format from the dropdown box "Save as type:", and save it. 


 
Files in *.xlsm format. 






In addition, when the workbook is opened, Excel will disable macros by default. The sheet catalog could display only when clicking "Enable Content" button. 





↑ Back to the top




If it does not work all the same, you are suggested to dig the Forum for any great solutions.  


We welcome all of your comments and suggestions! 
 

We welcome all of your comments and suggestions After your experience of EeeKB, if time allows, please score this article in the feedback table at the page bottom. We will appreciate your help for our improvement. Any recommendation or good ideas will also be welcomed in "Additional Comments". (For faster solution to your problem, technical queries could be put into discussion in appropriate posts at the Microsoft Community)
  

↑ Back to the top

Keywords: kbinfo, kbhowto, kbstepbystep, kbtypenonkb, kbpubtypesc, kbexpertisebeginner, kb

↑ Back to the top

Article Info
Article ID : 2740211
Revision : 1
Created on : 1/7/2017
Published on : 5/23/2014
Exists online : False
Views : 295