Software

Ask something
Question Locked

Excel flickering

0 helpful
3 replies

by simon.c.l

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an excel document that I have created. It is mainly a set of resources that I and my colleagues refer to in our work. It contains 6 worksheets, approx 6 recorded macros, a handful of hyperlinks and a number of simple functions.

The document seems to conflict with all the other open applications and often causes all the open windows to flicker erratically, stopping only when I hold down the excel title bar.

I have tried adding the Application.ScreenUpdating codes in my macros but they do not seem to make any difference - the macros are generally not in use when the flickering occurs but it usually occurs simply when switching between applications.

It is really getting on our nerves and I don't know if I have used the ScreenUpdating code correctly or if it is just something completely different.

Any ideas would be most welcome.

3 replies

by chris910

It sounds as if you have a macro that is continuously running. You might open the document without the macros enabled as a test.

by simon.c.l

Hi. Thanks for the reply. I'll give it a go when I get back to work. I can't see how any would be running, though, as they are all executed by buttons. However, I've just considered that as there are anything up to 20 people accessing the document at any one time, it's probable that someone else could be executing the macros. Could that affect another user and cause the flickering?

This discussion is closed to new replies.