Macro's

J

Jay Fastiggi

If I delete/remove a macro after the formula's have used the macro to
tabulate calculations, the next time a go into the file will the amounts
still be there? Or does the macro need to be in place at all times?
 
D

Dave Peterson

If it's a macro that places values (or builtin formulas) into cells, then you
don't need the macros.

But if it's a UserDefinedFunction macro (and there are cells that use that
formula), then you'd need that code. (Or convert those formulas to values.)

And when you're cleaning up the macros...

Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros
 
Top