Hey all. Ive been working on some stuff lateley, and I need a few bits of info on visual basic and excel
first off; when you are editing a macro in visual basic, is there a way to determine the size of the macro (disk space it will take up) while you are editing it, or just simply a way to find out after you save it
Also, if you have a saved sheet, that you delete the macros from, and resave it, will it still be the same size?
Lastly, is there a way to determine where all the space is comming from on an excel sheet? (im trying to fix one at work that is 2.5 megs!!)
This is all on office 2000 btw =). Thanks in advance
you might give the "Programmer's Paradise" a shot with this topic.