Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What macro command to turn off page refresh
I am using SheetActivate to run a macro to position the cursor in a specified
cell with the selected cell being in the top row, regardless of where the cell may have been when the worksheet was last active. I'm doing it by selecting a cell in the macro that is in a row further down in the worksheet and in a column further to the right than will display when the cell I want is selected. I then select the desired cell and the cursor is positioned as I want it. Everything works just fine. But, are there Excel commands that will turn off the page refresh and subsequently turn it back on to prevent the screen flicker when the cursor is repositioned? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What macro command to turn off page refresh
application.screenupdating = false
'Your code here Application.screenupdating = true -- HTH... Jim Thomlinson "CurtB" wrote: I am using SheetActivate to run a macro to position the cursor in a specified cell with the selected cell being in the top row, regardless of where the cell may have been when the worksheet was last active. I'm doing it by selecting a cell in the macro that is in a row further down in the worksheet and in a column further to the right than will display when the cell I want is selected. I then select the desired cell and the cursor is positioned as I want it. Everything works just fine. But, are there Excel commands that will turn off the page refresh and subsequently turn it back on to prevent the screen flicker when the cursor is repositioned? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What macro command to turn off page refresh
You can sandwich your code like this,
Application.ScreenUpdating = False 'Your code here Application.ScreenUpdating = True Regards, Alan. "CurtB" wrote in message ... I am using SheetActivate to run a macro to position the cursor in a specified cell with the selected cell being in the top row, regardless of where the cell may have been when the worksheet was last active. I'm doing it by selecting a cell in the macro that is in a row further down in the worksheet and in a column further to the right than will display when the cell I want is selected. I then select the desired cell and the cursor is positioned as I want it. Everything works just fine. But, are there Excel commands that will turn off the page refresh and subsequently turn it back on to prevent the screen flicker when the cursor is repositioned? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What macro command to turn off page refresh
Thanks, Jim and Alan.
"Alan" wrote: You can sandwich your code like this, Application.ScreenUpdating = False 'Your code here Application.ScreenUpdating = True Regards, Alan. "CurtB" wrote in message ... I am using SheetActivate to run a macro to position the cursor in a specified cell with the selected cell being in the top row, regardless of where the cell may have been when the worksheet was last active. I'm doing it by selecting a cell in the macro that is in a row further down in the worksheet and in a column further to the right than will display when the cell I want is selected. I then select the desired cell and the cursor is positioned as I want it. Everything works just fine. But, are there Excel commands that will turn off the page refresh and subsequently turn it back on to prevent the screen flicker when the cursor is repositioned? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
Cells turn 'hot' and execute distant macro button | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Using macro for page break | Excel Discussion (Misc queries) |