How to save & send Excel files without macros.

[CC]

When I send files (2003) my macros go with them. I don't want to have to
always 'cut and paste special' to get rid of them. Surely there is a way to
turn them off once I have run them or to save without active macros?

Thank you for any help.

 

[Ron de Bruin]

If you install my mail add-in you have a option to delete code and copy as values
http://www.rondebruin.nl/mail/add-in.htm

 

[CC]

Seriously, that's it? There is no setting I can set? No way to save without
active macros?

Thank you for your solution, but shouldn't there be an internal way to do
this?

-CC

 

[JP]

Why not use the personal macro workbook to store your code, you can
still use the macros, but that way the other workbooks you save won't
have them.

--JP

 

[CC]

I am using my personal macro workbook (didn't have that back when I used
macros a lot). Still, when I save & send, the macros go with it. Got to be
a control for that somewhere? I tried closing the workbook "personal" that
opens automatically when i open excel.

Cc

 

[Gord Dibben]

If you are running macros only from Personal.xls, your workbooks should not
have macros.

Sounds like your workbooks have their own set of macros or event codes.


Gord Dibben MS Excel MVP

 

[Sue Desver]

For years I have used the simple logic of cutting and pasting the entire file into a new file and then using save as. The new file created does not have macros in it

Sue D.