I have code that will creates a new excel file from a template, I want this new file to be read only and not have macros...or at least no command button copied so the macros can't be run from the copied file...any thoughts.

Tried to save( print it as PDF) but it wouldn't work how I wanted it to. I also am going to want to export data to a queryable access database so have the file as pdf won't really work for me.