re:how to delete macros&worksheet automatically before saving


Posted by raj on September 04, 2001 10:26 AM

i have developed a macro which i want to delete along with the extra 2 worksheets before saving, as it take way too much space on the 1.44floppy dis. I generally delete it manually before saving the worksheet which hasthe data, but it is too tedious. YOUR ASSISTANCE WILL BE VERY HELPFUL.



Posted by Ronnie on September 04, 2001 2:18 PM


Why not just record a macro that copies the worksheets you want to retain into a new workbook and saves the new workbook to a disk.