XL98: File Size Increases After Starting Visual Basic Editor

WORKAROUND

To work around this behavior, use the following appropriate method.

If Your Workbook Does Not Contain Any Visual Basic Modules or UserForms

You can reduce the size of your file by following these steps:

1. If the workbook is currently open, save the workbook, and then close it.
2. Close the Visual Basic Editor if it is running.
3. Open the workbook.
4. Save the workbook.

The size of your workbook will be reduced by approximately 1,500 to 3,000 bytes for each worksheet and chart sheet that it contains.

If Your Workbook Contains Visual Basic Modules or UserForms

If you are using Visual Basic modules or UserForms in your workbook, then you can reduce the size of your file by deleting any unused worksheets. To delete an unused worksheet, follow these steps:

1. Activate the worksheet by clicking on its sheet tab.
2. On the Edit menu, click Delete Sheet and click OK.

When you save your workbook, the size of the workbook will be reduced by approximately 1,500 to 3,000 bytes for each unused worksheet that you delete.