| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there an equivalent to windowsoff in Excel macros?
I am trying to write a macro in Excel and want to stop the display from
changing until the end. 1-2-3 had commands windowsoff and windowson which achieved this. Is there anyway of doing this in Excel?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there an equivalent to windowsoff in Excel macros?
Try
Application.screenupdating=false your code Application.screenupdating=true "Kiteman22" wrote: I am trying to write a macro in Excel and want to stop the display from changing until the end. 1-2-3 had commands windowsoff and windowson which achieved this. Is there anyway of doing this in Excel?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there an equivalent to windowsoff in Excel macros?
Application.ScreenUpdating = False 'Suppresses updating
Application.ScreenUpdating = True 'Allows screen updating Regards, OssieMac "Kiteman22" wrote: I am trying to write a macro in Excel and want to stop the display from changing until the end. 1-2-3 had commands windowsoff and windowson which achieved this. Is there anyway of doing this in Excel?? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there an equivalent to windowsoff in Excel macros?
On Oct 22, 4:16 pm, Kiteman22
wrote: I am trying to write a macro in Excel and want to stop the display from changing until the end. 1-2-3 had commands windowsoff and windowson which achieved this. Is there anyway of doing this in Excel?? you can use screenupdation as false, try the below code Application.ScreenUpdating = False |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| @DSUM (123) equivalent in excel | New Users to Excel | |||
| What is Date() equivalent in Excel? | Excel Programming | |||
| Autotext equivalent in Excel? | Excel Programming | |||
| Excel equivalent of 'Keep lines together' | Excel Programming | |||
| Lotus 1-2-3 {Windowsoff} | Excel Programming | |||
Linear Mode
