I have an Excel file that is about 900,000 bytes in size which I am developing for a group of people to share. There are about a dozen tabs and macros to perform data entry in the worksheets, and some worksheets are used to run reports from data in the other worksheets. VBA and a form are used in this application. Cell bordering exists for all used cells, and is added by VBA when a report is run.
I want all the worksheets to appear unformatted in the areas outside of the cells that are used. This would be like a new worksheet where the cell borders are grey.
I tried removing border formatting by clearing the borders of all unused cells using Format Cells/Border to do this, and this increases the size of the workbook significantly. I also tried copying unformatted cells from another worksheet to all unused cells of a report worksheet, but that increases the file size by several megabytes also.
Question: how do I unformat unused cells that have black bordering, so that the bordering will appear grey, and doing this without adding to the file size.
Unused cells are deleted by the VBA code and this controls the file size, but I would like to control each worksheet's appearance by having all the unused cells appear without black borders. The black borders don't go away after the rows are deleted.