Excel VBA

wrom

Junior member
  • Nov 23, 2009
    95
    9
    8
    I created excel sheet with VBA from Excel 2010. When I saving the file it ask me to save it as "Macro - Enabled work book" otherwise vba part is not working. So I saved the file as Macro - Enabled one. But the problem is that the file size is large (Around 45 MB) .
    I can't place this size of file in our office network. Does anyone knows how to reduce the file size. Thanks in advance.:confused::confused::confused::confused:
     
    Last edited: