Check Performance Message

[keith3700]

I keep getting a "Slow Workbook", "Check Performance" message.
Is there a way of deleting the message using VBA?
I have others using the workbook, and they click the check performance button which removes most of my formatting.

 

[Logit]

Why is your workbook creating those messages ? Correct the issue ... not cover it up.

 

[keith3700]

Why is your workbook creating those messages ? Correct the issue ... not cover it up.

Hi Logit, thanks for the reply.
I have colored cells on the menu sheets with control buttons.
I don't want to delete the colored cells as it looks bland ...

I am happy with the performance and don't have issues with it ...
Surely I can have the option of turning off this performance message ??

 

[Logit]

There is a command "Application.DisplayAlerts = False" that can be used to stop some alerts messages from being displayed.

Sub foo()

Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True


End Sub

 

[keith3700]

There is a command "Application.DisplayAlerts = False" that can be used to stop some alerts messages from being displayed.

Sub foo()

Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True


End Sub

Hi Logit, No didn't work.
I placed it in the Private Sub Workbook Open. No luck, so then ran it in a sub, still no good

 

[Logit]

You'll need to determine what is causing the error messages and make the correction.

 

[Peter_SSs]

I keep getting a "Slow Workbook", "Check Performance" message.
Is there a way of deleting the message using VBA?

I'm afraid not.
Have a look at this and also the link in its first paragraph.

BTW, I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)