Emailing Spreadsheets with embedded Macros

Whilst I have a reasonable understanding of Access, I am a dim-wit when looking at Excel code ... please advise me.

I am Emailing out Excel spreadsheets to our Club Executive which now contain macros and VBA.
(Thanks to this forum that I am able to do that!)

It seems that some ISP's don't like the attachments, as they see them as a threat (or at least a potential threat).

Apart from a freeze panes and a filter on a row, I don't need anything fancy for them to run. Just the actual data in the rows and columns.

They just need the membership details .... all the code/macros was written to drag the data from access tables and format it.

As a possible solution, I wondered whether it would be possible to do a complete copy on each page's data and paste it back on the same page as PasteSpecial .. values.
And then delete all the macros and VBA code.

Does this sound stupid?

My thinking is that without the code, the ISPs will probably accept the attachments, as I never had problems with the spreadsheets that I used to generate in Access ... possibly because there was no code/macros in them.

Or is there a simple solution ?... but one which must not involve the receivers of the Excel spreadsheets changing anything their end.

I hope this all makes sense!

Do you run the macro manually, then send the spreadsheet?

If yes, then you can store the macros in your PERSONAL.XLS file.

run the macros on the workbook that you need to run it on, then send a normal spreadsheet to your recipient.

Robotatcha21010 Thnaks for your response.
Using Access 2003 I build 5 tables.
I have 5 Excel 2003 spreadsheets each one of which , using code in Private Sub workbook_open() in Thisworkbook, I 'automatically' import the Access table, and massage it using VBA and Macros. It then, again automatically, gets attached to an email and sent to the recipient.

So to answer your question, No ... I don't send it manually.

I am not sure what a PERSONAL.XLS file is ... I shall research and see it I can work something out using it.
Thank you.

Thanks LewisWA02.
I appreciate your assistance.
The files all have an extension .xls
The macros work using this extension.
I ran Norton360 against them and sent a copy of the 'cleared' status with the spreadsheets, so Norton thought they were OK.
I was hoping for a solution which doesn't involve my users having to do anything other than open the spreadsheets.

Any further ideas?

Jaslake.

Roylake seems to have answered my problem ... but if I have further issues I will definitely try your suggestion.
All I will have to do is try to find out how to do it!

Thank you both for your time and advice

RoyUK.

I did as you suggested and my recipient was able to open it OK.
Thank you.