Auto Calculate Progress Bar

[tmmellor1981]

Morning All

I've looked through mr excel and various forums and can find various code relating to progress bars on vba forms but not what I need the workbook to do.

I have a large workbook which takes around 3 mins to auto calculate as a drop down box with date rolls all the figures along by a month and performs about 40,000 calculations. The small auto calculate status at the bottom is small and often missed by other users and was hoping to have something large or more visual to let users know they sheet is calculating. Alternativley I would just be as happy with a msgbox to stay on screen whilst auto calc is being performed so they know something is happening

thanks for the great site i'm sure this is simple enough for one of the guru's in here

 

[jumbledore]

why don't you use Workbook_Open() to stop access and Application.AfterCalculate event to give access, once the calculations are complete. Just a suggestion

 

[njimack]

There are plenty of examples online of progress bars either using userforms or the statusbar...

Progress Indicator in Excel VBA - Easy Excel Macros
Progress meters
Spreadsheet Page Excel Tips: Displaying A Progress Indicator
Progress Indictor

 

[tmmellor1981]

thanks for replies. I don't want to stop what it is currently doing i just need users to be aware auto calc is running (normally you get a small value in bottom left.

njimack i tired all those link and are all for vba forms, the auto calc is being performed automatically in excel it's not something i have coded in so non of these can be used

looks like this isn't possible, is the alternative msgbox on auto calc easier to implement ?