VBA Worksheet_Deactivate() problem

Philip Morris 0 Reputation points
2023-08-26T20:17:53.0466667+00:00

I have used Worksheet_Deactivate() to run a macro.\ when ending an update on 1 sheet. When I click on another sheet tab the macro runs but it stays on the same sheet. I can't get to another sheet.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,425 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,438 questions
{count} votes