VBA Code running very slow. Need help

Folks,

The attached file is working well but very slow. Can you please someone advise how I can make these codes run fast.

Thanks in advance.
Joshi

You have the code password protected.

Hi Mike,

Sorry.. Unprotected workbook attached. Thanks in advance.

Joshi

Also what is running slow? Which code? And give some details to as how to run your forms?

Hi Mike,
If I hit any button in the userform, its taking too much time to execute.

Thanks in advance.

Joshi

There a bunch of textboxes, comboboxes. Explain how the program is to flow. I'm sure you just don't open the form and hit a button?

Hi Joshi

It's my experience that Printing Worksheets or Creating PDF's of Worksheets are inherently slow(er) processes.

The Single Report Buttons appear to work as expected...no observable, unexpected delay.

The All Report Buttons also appear to work as expected...the delay is the number of records being processed...2339 in your sample file. Now I've not timed these processes as I've no desire to print 2339 reports or create 2339 PDF files.

The best I can suggest...start the Code...have a smoke or a cup of coffee...let it run.
You might consider breaking it up into smaller selections...though I don't know what this buys you if you want them all.

PS: A late thought...you could do Multi Select on the All Buttons such that you Print/PDF only those you want...If you TRULY want them all...well...have a smoke or coffee...make certain you have adequate paper in the printer...

Hi Joshi

I found some Code today that might make your situation a bit more palatable...it's called Excel4Macro pSetUp. Let me play with it a bit...see if it helps.

Hi John,

Any updates?

thanks,
Joshi

Hi Joshi

Sorry, no...could not find anything.