OK so here is the scenario
smart alec me decides the auto calc function makes the workbook way to slow
so I make the Workbook manual on startup
Add this to the from of my code
some code here
a bit more code
but it seems that the me.calculate does not work whilst the application.x = False
is there a way around or am I missing something
Martin
smart alec me decides the auto calc function makes the workbook way to slow
so I make the Workbook manual on startup
Add this to the from of my code
Rich (BB code):
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Rich (BB code):
some code here
Rich (BB code):
me.calculate
Rich (BB code):
a bit more code
Rich (BB code):
Application.EnableEvents = True
Application.ScreenUpdating = True
Application.DisplayAlerts = True
but it seems that the me.calculate does not work whilst the application.x = False
is there a way around or am I missing something
Martin
Last edited: