Hi N,

(1) Post the problematic code

(2) See Chip Pearson's page on programming to the VBE at:


See particularly the section entitled:

Deleting All VBA Code In A Project


---
Regards,
Norman



"nbaj2k" wrote in
message ...

I have my macros all done up doing exactly what I want. I have run into
2 problems however.

When I have it set to save a file, if the filename already exists, it
asks if I wish to overwrite, if I say yes, it continues on fine, if I
say no, the macro stops and crashes, saying

"Run-time error '1004'
Method 'SaveAs' of object '_Workbook' failed

Is there a way if I say no for it to continue on instead of crashing?

The other problem I have is when I send out reports that I used macros
to create. I just want people to be able to view the reports of the
data, but instead a box comes up when they try to open them saying that
the file contains macros, and that "Macros may contain viruses, it is
usually safe to disable macros". Is there anyway of automatically
removing any macros from a file before it sends?

Any help would be great!,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=569162