D
Dan Wasser
How do I delete ALL the macros, in a specific workbook, in
one fell swoop? (I'd prefer to do it in a macro, and then
delete THAT macro, too.) I have a 6000-line macro, made
up of about 50 "sub"-macros, in my workbook. Because of
that, it's about a 1MB file. But I want to be able to
send the workbook to other people without their having to
deal with the macro/security issue and also I want it to
be a (much) smaller file. But it takes WAY too long and
WAY too many steps to delete each macro one-at-a-time.
For various reasons, I don't want to copy-and-paste
(special, values only) to a new workbook. Thanks. Dan
one fell swoop? (I'd prefer to do it in a macro, and then
delete THAT macro, too.) I have a 6000-line macro, made
up of about 50 "sub"-macros, in my workbook. Because of
that, it's about a 1MB file. But I want to be able to
send the workbook to other people without their having to
deal with the macro/security issue and also I want it to
be a (much) smaller file. But it takes WAY too long and
WAY too many steps to delete each macro one-at-a-time.
For various reasons, I don't want to copy-and-paste
(special, values only) to a new workbook. Thanks. Dan