Unable to find macro

[DougStroud]

I am on a Mac, using Excel 2011.
I purchased a workbook which is a simple invoice with a macro to calculate; item totals, qty ordered, sales tax, deposit, payments, etc... I switched around one of the cells that was incorrectly ordered and is auto-calculating a negative number. I need to alter this to a positive number. When I open up macros, the dialogue box shows no macros in the current worksheet, or workbook. I also looked in the cell to see how the cell was formatted to see if that was the issue, but alas the cell still returns a negative number when I manually enter a positive number.

Any thoughts in how to correct?

 

[Fluff]

If it's being done via code, then you will need to modify that code.

 

[DougStroud]

If it's being done via code, then you will need to modify that code.

I disabled the macro upon launching the sheet and that did in fact correct the issue. How do I find the code? I have attached screen shots showing that the worksheet has no macros, but it does? How do I proceed?

*edit- My uploads are not displaying.

 

[MARK858]

When I open up macros

With the above do you mean when you open the VB Editor or click on Macro's in the below image?

 

[DougStroud]

With the above do you mean when you open the VB Editor or click on Macro's in the below image?
View attachment 27333

I am going to "Tools" on the file menu and then selecting "Macro" >> "Macros" and a dialogue box opens. I wish I could upload an image. The button is there, but after it uploads it does not present in my post.

 

[Fluff]

It's probably using what's called Event code, use Alt F11 to open the VB Editor and double click the name of the project

 

[DougStroud]

It's probably using what's called Event code, use Alt F11 to open the VB Editor and double click the name of the project

Ahhhh- Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.