Reputation: 49
I am trying to copy sheets from a macro enabled Excel file (.xlsm) to a non-macro enabled file (.xlsx). I believe that some change have been recently made to Excel that is preventing using the process I used before: Include in the a VBA code that saves the ".xlsm" as ".xlsx" the following instruction: "Application.DisplayAlerts = False".
I tried the following process (and it almost worked!):
I was unable to save the non-macro enabled file, created by the above process, because an error window popped up with four buttons: "Save", "Save and erase features", "Go back" and "Help". The previous method "Application.DisplayAlerts = False" no longer worked.
Code triggered by activeX controls were copied to the ".xlsx" file, as well. I solved this problem by removing sheets that had elements like: buttons, activeX controls, etc. Then I could save the ".xlsx" file. I will have to restructure, or get rid of, some code that are triggered by activeX controls.
But, some links to the ".xlsm" file were created in the ".xlsx" file. I was unable to understand the reason.
Upvotes: 1
Views: 481