Deleting macro after saving

[Hans_]

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!!

[Tom Ogilvy]

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_" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>