The bigger issue is how the Application.ScreenUpdating is set and when it is set, but no one can provide a definitive answer to that from the hours of reading I have done on it.ġ) Somehow set the cursor focus to a specific cell on a sheet with out activating that sheetĢ) Figure out how and when the Appication.ScreenUpdating works and resets between proceduresģ) Move my code from Worksheet_Activate to some other event handler routine (e.g. So, for example, I have a button called "Reset All Sheets to A1" which does just that, but I do not want the screen flashing to be seen by the user as the sheets are traversed one by one. When that happens the "Worksheet_Activate" event handler kicks in and I do not want that to happen as the Application.ScreenUpdating = False/ True setup is "wacky" and somehow resets to True. The application offers some easy-to-use functions such as highlight cursor, mouse spotlight, keystroke visualization, magnifier and on-screen annotation. Download Now PointerFocus is a handy toolbox for presenters, trainers and demo makers.
The issue is not that the Select statement is used per se, but rather that the sheet where I'm placing the cursor becomes Active when the focus occurs. Pointer Focus Registration Code - neonvirgin.
0 kommentar(er)
