disable a macro

B

badamsios

Can I disable a macro before saving a workbook? IF so, will it make
the book smaller?
Is there any way to make the file smaller/compress it from WITHIN
excel? The person asling will never follow zip before attaching.
 
G

Guest

If the issue is file size then disabling or removing the macros will not
significantly reduce the file size. While there are things you can do to
reduce file size there is not too much you can do to compress the file. You
can look at thes link to reset the used rage which is the normal culpret when
it comes to bloated file sizes...

http://www.contextures.com/xlfaqApp.html#Unused
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

security, enabling macros to enable a disabling saving function 12
Huge spreadsheets, anything I can do? 2
Macro "not to check compatibility when saving this workbook" 4
Addin not allowing thisworkbook.save in before save event 3
Excel Cannot delete empty cells/rows 4
Run code from another workbook 7
Excel button problem 2
Copy & Paste from One Workbook to a Macroed Template Workbook 1

Top