Thank you all for your input and suggestions. Time permitting, I'm going to
try some of your suggestions to see if they help. I am encouraged in that it
doesn't seem that the file is too big. It would be nice to cut down the size
though.

Thanks,

--
Robert


" wrote:

Hi Robert,

Probably not without removing functionality.

OTOH - you might not require all the functionality you have.

You could split the VBA modules into separate categories:

1. Those required to fetch and sort data, and
2. Those required to manipulate drop downs and Excel controls.

Modules in category 1 can be placed into an Add In.

A similar analysis applies to your WorkSheets:

1. Those required to fetch and sort data can be placed in an Add-In.

---

Now. If the Workbook is an audit and you're sharing the data with an
auditor - you have fewer options than if the workbook is used as an
application.

If the Workbook is used as an application you can store the data in a
database instead of Worksheets.

---

If there are clusters of modules and forms - you can export them and
load them on an as-needed basis - but I doubt you want to go that
route.