Why Does Zipped File Size Grow When Workbook Is Protected?

Beedy

New Member
Joined
Oct 5, 2005
Messages
3
My code compresses a file using Windows 'Send To > Compressed Folder' utility and sends the compressed folder via email. When I protect the workbook without a password the compressed file is about 1 MB but when I protect the workbook with a password the zipped file increases to about 6MB. The workbook itself is only 7MB. Why does the file size increase?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,941
Members
412,299
Latest member
agentless
Top