Which macro (of many) changes the data in my workbook [Closed]

Report
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the program is run based on different data inputs. I am trying to find out what is putting the data there. When you click on the cells it simply shows text with no formula and there are no "precedents" that show. How can I find the macro or formula putting the data there?

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi Gary,

That is hard to say. My advise would be to use Ctrl+f on all the codes you have and look for the sheet reference.

If you can't find it, then consider uploading your workbook (always be careful with sensitive data) using a site like wetransfer.com and then post the download link here. If you do, then mention which cells on which sheet is changing and with which action the change happens.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!