GaussBonnet
New Member
- Joined
- Aug 4, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I have multiple worksheets that contain Worksheet_Change and Worksheet_Calculate Macros. After one of these macro is run, when I press the F2 key, I enter the editing mode in the cell, but the range in the formulas are no longer highlighted. I then have to close the file and re-open it without running a macro to be able to see my references highlighted.
How can I keep seeing the highlighted references when pressing the F2 key after a macro has run?
Thanks for the help
I have multiple worksheets that contain Worksheet_Change and Worksheet_Calculate Macros. After one of these macro is run, when I press the F2 key, I enter the editing mode in the cell, but the range in the formulas are no longer highlighted. I then have to close the file and re-open it without running a macro to be able to see my references highlighted.
How can I keep seeing the highlighted references when pressing the F2 key after a macro has run?
Thanks for the help