Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting macro after saving
Hi all, I have my file working now. But, the only thing i want is that i get screen to so that i have so save my file under an other name in directory i can select. And after that i want the macro to delete the form (including the macr that is in it..) So, the next time i want to open the saved file ther are no macro's or forms in the file. Is that possible? Thanks! -- Hans ----------------------------------------------------------------------- Hans_'s Profile: http://www.excelforum.com/member.php...fo&userid=2561 View this thread: http://www.excelforum.com/showthread.php?threadid=39068 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Auto-Filtered Data (or deleting the rest) | Excel Discussion (Misc queries) | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Saving without deleting previous input | Excel Worksheet Functions | |||
Deleting Row Macro | Excel Worksheet Functions | |||
Deleting data in cells while saving formatting & formulas | New Users to Excel |