Bloat file size

[SIGE]

Hello,

I have a workbook in which I have a bit of code ... a couple userforms, a couple modules.

Which is 90kb in size.
On 1 of the sheets i hide "all" columns and "all" rows ... well, A1:Z100 remains visible.
after saving the file, it becomes 2890 kb ... I tried this several times now, with always the same result.

any suggestions?

Sige

 

[SIGE]

I am just unlocking the sheet to "empty" "A3", no?
I guess I could do ...


With UserAdministration
.Unprotect pword
.Range("A3").Locked = False
.Range("A3") = ""
.Range("A3").Locked = True
.Protect pword
End With</pre>
but the bloating effect remains the same ...

 

[RoryA]

But was the file already bloated when you did that?

 

[SIGE]

no no, the "previous-state" version is at 89 kb.

 

[RoryA]

First test: comment out all the BeforeClose code and see if the bloat still occurs?

 

[SIGE]

I copied all the code and transferred the Userforms modules to a fresh workbook ...

Then, hiding my rows and columns again. Closign the Wb, saving the Wb
And no bloating...

The problem seems resolved, but the cause of it intrigues me ...