I have a question. I have an a bunch of excel sheets with several macros in them. And I need to save this document as xls which basically deletes the macros. Once information is added to the sheets I will change the format from xls to xlsm.
My question is: Is there a way that I can create a button that would some how retain the macros when I save the sheets as xlsm and then when I open the xls sheets and change the extension to xlsm and push a button the macros would be enabled in the doc. Basically I need the macro code to be buffered and then released when I push a button.
I don't think this is possible but any suggestions would be appreciated. The reason I need to change to an xls extension is I need to upload the doc on a server and unfortunately macros need to be disabled.
Bookmarks