lagrangePoint3
New Member
- Joined
- Jun 22, 2022
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
I made a macro to put a check mark into a cell.
Then I made it into a button and put it on the Quick Access Toolbar in the Personal Workbook.
When I run the macro, it puts a checkmark into the initial cell, but then moves the cursor into a different cell.
It always moves the cursor into the same different cell, though.
I would like it to stay on the cell it's putting the checkmark into.
While I was creating the macro, it grayed out the Stop Macro Recording button until I moved the focus out of the cell.
I didn't move to the cell it's ending on though, just moved into the next cell to it's right.
If I want to retain the same cell as the checkmark at the end of the macro, do I need to move it to a different cell as I did, and then move it back again?
I'll try that as I wait for your reply. Thanks.
Then I made it into a button and put it on the Quick Access Toolbar in the Personal Workbook.
When I run the macro, it puts a checkmark into the initial cell, but then moves the cursor into a different cell.
It always moves the cursor into the same different cell, though.
I would like it to stay on the cell it's putting the checkmark into.
While I was creating the macro, it grayed out the Stop Macro Recording button until I moved the focus out of the cell.
I didn't move to the cell it's ending on though, just moved into the next cell to it's right.
If I want to retain the same cell as the checkmark at the end of the macro, do I need to move it to a different cell as I did, and then move it back again?
I'll try that as I wait for your reply. Thanks.