D dotchieJack Member Apr 7, 2016 #1 Hi, Is there a way that a workbook only can be saved as a macro enabled workbook? Thank you
N NARAYANK991 Excel Ninja Apr 7, 2016 #2 Hi , Using VBA , as shown in the following link : http://mattiaslundstedt.com/force-save-excel-file-as-macro-enabled/ Narayan
Hi , Using VBA , as shown in the following link : http://mattiaslundstedt.com/force-save-excel-file-as-macro-enabled/ Narayan
D dotchieJack Member Apr 7, 2016 #3 Hi Narayan, Works like a charm Thanks again, you are such a great help
K Kavfam New Member Apr 8, 2016 #4 dotchieJack said: Hi, Is there a way that a workbook only can be saved as a macro enabled workbook? Thank you Click to expand... When you choose File tab and Save As, you can select Save as Type and choose macro enabled from the pick list.
dotchieJack said: Hi, Is there a way that a workbook only can be saved as a macro enabled workbook? Thank you Click to expand... When you choose File tab and Save As, you can select Save as Type and choose macro enabled from the pick list.
