Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
View "Going To"
Not really a biggie but I have some userforms which do various things
to my sheet. As the userforms input data in my cells, Excel does not scroll down automatically to the table (cell) being inputted to... However when my VB instruction to change a cell colour happens, Excel scrolls up or down to the show the cell that has changed colour. Anyway to stop this so Excel doesn't navigate to the cell being affected? Thanks, Craig -- The Zero ST |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
View "Going To"
Try adding APplication.ScreenUpdating = FALSE at the beginning of the
affected code and Application.ScreenUpdating = TRUE at the end of your code. HTH, Barb Reinhardt "Craig Coope" wrote: Not really a biggie but I have some userforms which do various things to my sheet. As the userforms input data in my cells, Excel does not scroll down automatically to the table (cell) being inputted to... However when my VB instruction to change a cell colour happens, Excel scrolls up or down to the show the cell that has changed colour. Anyway to stop this so Excel doesn't navigate to the cell being affected? Thanks, Craig -- The Zero ST |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
"Show Placeholders" in options/view menu does'nt work. | Excel Discussion (Misc queries) |