I wonder if there is a way to save the workbook without saving the macro.
I have a data source driver set up on my machine, which retrieves the data from the database and the macro is in the open workbook event. the worksheet is posted, therefore, I don't want other users to hit 'enable macro' because the macro will run into error.
It would be nice to save the workbook without saving the macro. Is it possible?
Thanks,
ActiveWorkbook.SaveAs Filename:= _
"path/to/filename.xls", _
FileFormat:=xlNormal, ReadOnlyRecommended:=True, CreateBackup:=False
I have a data source driver set up on my machine, which retrieves the data from the database and the macro is in the open workbook event. the worksheet is posted, therefore, I don't want other users to hit 'enable macro' because the macro will run into error.
It would be nice to save the workbook without saving the macro. Is it possible?
Thanks,
ActiveWorkbook.SaveAs Filename:= _
"path/to/filename.xls", _
FileFormat:=xlNormal, ReadOnlyRecommended:=True, CreateBackup:=False