View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Deleting macro after saving

Chip Pearson's site has sample code for delete code and so forth with code:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Hans_" wrote in
message ...

Hi all,

I have my file working now. But, the only thing i want is that i get a
screen to so that i have so save my file under an other name in a
directory i can select.

And after that i want the macro to delete the form (including the macro
that is in it..) So, the next time i want to open the saved file there
are no macro's or forms in the file.

Is that possible?

Thanks!!


--
Hans_
------------------------------------------------------------------------
Hans_'s Profile:

http://www.excelforum.com/member.php...o&userid=25618
View this thread: http://www.excelforum.com/showthread...hreadid=390688