Save xlsb copy without macros

[S Oberlander]

I have this large xlsb file on the server that I need to protect from accidentally saving edits from users.
I've debated saving it as a template but I'm afraid the file is too heavy to store as a template.
I don't want to protect it against edits because I don't want it should be too complicated for the user to use...
If I use any workbook event handler then that will get saved when along with the new copy of the file created by the user creating a situation where the user must create a new copy for every edit.... (either opening as read only, or disabling the option to save)

So I'm wondering if I can somehow (thru workbook event handlers... lol) save a copy as an xlsb, but strip it of any macros before saving.
Any help or any other suggestions would be appreciated

 

[Jeffrey Mahoney]

The VBA project doesn't add that much overhead to an Excel file. Saving an XLSB will save any macros. Saving a .XLSX will strip the macros. Making the file READ ONLY on the server using your file explorer will prevent overwrite.

So, you want them to be able to overwrite the file, but get rid of the macros? You don't want them to have to save to a new file name?

 

[S Oberlander]

My overhead is not in vba.
The file has some six hundred thousand rows.
My idea would be to have a beforesave event that cancels the save, does save-as instead, and then the macro should erase itself as it has completed its job. I just don't know how to do something like have a macro erase itself (If it is at all possible).

 

[Jeffrey Mahoney]

Nope. Adding, editing, or deleting VBA code is a precaution.

 

[S Oberlander]

Thanks for your time!