olddrummerguy
New Member
- Joined
- Sep 6, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I'm trying to make a spreadsheet be as user friendly as I can for upper management.
I have a spreadsheet that uses some VB code I found that sums certain cells on a specific worksheet based on the color of cells in one of the other worksheets. The problem is the sums dont adjust to data changes, You have to issue a CTRL + ALT F9 to get it to recalculate. It must be because this sun is really AB code.
Is there any way to have the manual recalculate be issued every time this specific worksheet is brought into focus ( clicked on)?
Thanks
I have a spreadsheet that uses some VB code I found that sums certain cells on a specific worksheet based on the color of cells in one of the other worksheets. The problem is the sums dont adjust to data changes, You have to issue a CTRL + ALT F9 to get it to recalculate. It must be because this sun is really AB code.
Is there any way to have the manual recalculate be issued every time this specific worksheet is brought into focus ( clicked on)?
Thanks