is there an equivalent to windowsoff in Excel macros?

K

Kiteman22

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??
 
O

OssieMac

Application.ScreenUpdating = False 'Suppresses updating
Application.ScreenUpdating = True 'Allows screen updating

Regards,

OssieMac
 
N

nayagamvalli

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??
Click to expand...

you can use screenupdation as false, try the below code

Application.ScreenUpdating = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pausing VBA execution to allow for full recalculation 1
Lotus 1-2-3 {Windowsoff} 2
Windows On/Windows Off 3
Select Text to End of Footnote 9
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Converting Lotus 123 macros to Excel - Sort by Due Date 1
Auto populate value from one task to another in MS PROJECT 0
Improving Macro That Keeps First Letter 0

Top