VBA Code to remove VBA

C

Cory Thomas

I have a project im working with right now, and the file sizes are muc
too large. I have a considerable about amount of data in th
spreadsheet and a lot of VBA code.

So I was wondering if there was a way to write code to remove the cod
in the spread sheet. I would much rather remove the modules and wha
not than to have to copy this data to another spreadsheet
 
C

Cory Thomas

Thanks for the links, i used Chip's method.

The reason i cant just right click and remove them is because im no
going to be running this spreadsheet. It is going to be run about 8
15 times a day. I dont want to make the people running the macro t
have to manually delete them to make the file size 50% smaller.

Anyways, thanks again for the link
 
Top