ScreenUpdating in Excel (Office97 + )

Topic

New Reply

Hi all,

Can you enlight me on this little enigma:

My scenario is this:

Application.ScreenUpdating = false
… work on cells, rows, cols AND controls in a sheet.
Application.ScreenUpdating = true

Is seems that turning ScreenUpdating on/off only has to do with cells only or maybe even only contents of cells. What I want to do i to completely turn off visual interaction from a sheet while updating it and then next turn it back on to see my result. While I work on it I must hide/show rows/cols and interact with a lot of controls on the sheet (lists, buttons, images etc.). Setting them invisible dos not seem to do me any good.

So I’m in a situation where I want a: Application.SeriousScreenUpdating = { True / False }

Any ideas?

Regards,
Michael.

Reply | Quote

Replies

Have you tried hiding the entire worksheet while you’re modifying it? (there must be at least one worksheet that remains visible)

Reply | Quote

Now I have… it seems to be *almost* possible – some controls (date ctrls) complains about this approch though. Perhaps making a huge shield of some sort – a textbox or something…

Anyway thanx’ to you Hans!

regards,
Michael

Reply | Quote

How about looping through a Flash presentation… or an “interesting” movie? You might never get the user back to the worksheet.

Alan

Reply | Quote

Or use Appel Mac. or …. *S*

Reply | Quote

Hi Michael,

Another approach would be to leave the worksheet visible, but temporarily hide its rows and/or columns.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

In my programs I also shut off calculation to speedup the application.
I use

Application.Calculation = xlManual
Application.ScreenUpdating = False

at the start and use

Application.Calculation = xlAutomatic
Application.ScreenUpdating = True

at the end.

Hope this helps.

Reply | Quote

I’d try two things:

1. Instead of opening the worksheet directly in the GUI, try creating a hidden instance of Excel and working thru that instance. When done, you could then make the worksheet visible. Of course, you will have to make sure that the operations you are performing can be accomplished with a hidden worksheet. Might require significant reprogramming to achieve this goal.

2. You could use the Windows API to lock the window.

Reply | Quote