Need to email a workbook but without the queries

[Monsignor]

Is there a standard practice for preparing and sending workbooks so that the recipient can't dig around in the queries? My initial thought is to just delete the queries because the static result is the objective. My concerns:

1. Forgetting to delete the queries, and sending the file off.
2. This is something that'll be done on a regular basis. So, deleting 10 queries each time would get old, fast.

What might be some ways to simplify this?

 

[ranman256]

as part of the 'Saving' process, the macro would:
delete all queries,
save As to a file w their name in it.
email said file.

 

[macfuller]

A macro will work if you have Excel 2016 and thus the queries are part of the data model. Rather than exporting the queries I suggest saving a copy first, then delete the queries in the copy, email the copy, and delete the copy (to avoid confusion the next time).

If you have Excel 2013 I don't see an automated possibility. I don't know if the schema tables that you can read for information about the queries allow deletion.