Prevent a worksheet from running in Jet

Hi all,

I have a report that calculates GL Expenditure. On the first worksheet is where you enter the chosen date range. I also have 12 other worksheets that automatically calculate the information for each calendar month. This report (due to all the calculations) takes about 8 minutes to run.

Is there a way to disable the 12 worksheets from running in Jet? If so, I could do some sort of IF statement whereby a user could enter YES or NO in a field in answer to if they wanted to run the monthly calculations. A 'YES' would enable the 12 worksheets to run and a 'NO' would stop them running, thus saving a lot of time.

Is this possible?

Many thanks, Paul


Please sign in to leave a comment.