Macros won't work in spreadsheet

[cmlashbrook]

Hello,

I've been using a spreadsheet that had a macro that moves a row to another sheet based on the content in a cell and it worked fine for months but suddenly stopped working. I tried inputting different macros to see if it was an error with the original, but none are working. Any idea why this might be? I triple checked the criteria, rows, and columns and everything should be right. Any idea why it would suddenly stop working. Others have access to this sheet so I'm wondering if maybe someone did something that would cause it to fail. There is no error message that pops up, it just won't remove the rows anymore like it used to, even when conditions are met. Below is the macro that I'm utilizing.

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have added them for you this time.)

[AliGW]

Are you trying to run this macro in the online version? Has anything changed in terms of workbook location?

[FDibbins]

Is the file saved as .xlsx or .xlsm?

If it has been saved as .xlsX, that format does not allow VBA, and your code will have been stripped from the file. If you have a back-up/copy somewhere you can retrieve the code, otherwise you may be SOL