Unwanted Message - Can't Find the Source

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
105
MrExcel Community,

I have a macro-enabled workbook with several event procedures. When my workbook re-calculates, I'm getting a message dialogue that has a single word, "Calculated". When I search my entire project for the word "Calculated" I can only find that in one comment. I checked for all MSGBOX statements to see if it could be coming from one of my user function procedure calls, but found nothing there. The title of the message dialogue just says "Microsoft Excel". Any ideas how to find the source of this message or to suppress it?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,251
.
One thought .. if your macro code has the line "On Error Resume Next" ... or if it has a call to an error handler .... disable those. Then run the code and see
if it errors out on a line of code that becomes highlighted in yellow.
 

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
105
.
One thought .. if your macro code has the line "On Error Resume Next" ... or if it has a call to an error handler .... disable those. Then run the code and see
if it errors out on a line of code that becomes highlighted in yellow.
Thank you for the suggestion Logit. I commented out all my "On Error …" statements including some "Resume Next" and some "GoTo …" but no error occurred and I still got the "Calculated" message.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,280
Office Version
365
Platform
Windows
Have you tried stepping through the Calculate event using F8 to see where it pops up?
 

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
105
No Fluff, but it sounds like a very useful suggestion. I just did some searching in a few help resources, this forum, and on-line, but didn't see any clear instructions on how to use F8 to do that. I went to my worksheet_change event code and tried repeatedly clicking the f8 key but didn't get any response. How do I step through the Calculate event?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,280
Office Version
365
Platform
Windows
If it's a Change event (or any code that contains that contains something in the () after the sub name) then you cannot use F8 directly.
Put the word Stop as the very first line of code in the event & then when the event triggers it will stop at that line & you can then use F8 to step through the rest of the code.
 

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
105
Thank you Fluff. This tip enabled me to isolate the issue to some "ActiveSheet.Calculate" statements. I have used these many times in the past for other projects and they did not trigger a "Calculated" message box. I have been looking through excel documentation for the calculate method and the Excel options, but so far I have not found anything that sounded related to this.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,726
Office Version
365, 2010
Platform
Windows, Mobile
Can you upload a copy of your workbook (you can clear the contents [clear not delete] any sensitive info as I am only interested in the code/validation) to either www.box.com or www.dropbox.com, mark it for sharing and paste the link it provides in the thread so we can look at it.
 
Last edited:

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
105
Thank you for the offer but I can't do that. The method and what I'm doing are sensitive, not the data. It would be a lot of work to disguise all the content.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,747
Office Version
2010
Platform
Windows
I would search project-wide for MsgBox and set a breakpoint on every one that isn't sending a literal string.

Also: got any add-ins?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,100,186
Messages
5,473,011
Members
406,843
Latest member
David_Welland

This Week's Hot Topics

Top