Application.screenupdating with subs

[vestax22]

Hi, I created a small Excel VBA application. This program ios seperated in several subs. One of the subs opens another workbook. Another sub extracts data from this workbook and close it. It seems logical that if I place application.screenupdating = false before calling these two subs and returning it to true afterwords that the screen would not update while the file is opened.

Is there anything I should know? I tried setting applicaiton.screenupdating to false inside each sub as well but it still doesn't work. Does screenupdating = false work when working with subs?

Thx in advance

 

[SkipVought]

hi ves,

I'd suspect if ScreenUpdating is being turned on, that SOMEHWERE in your code, its being assigned True.

Use Edit/Find and select the option button Search Current Project.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[vestax22]

Hi skip, I already had this problem and you were right, I found screenupdating = true in my code but this time I did try searching it and found nothing.

Any suggestions?

Thx

 

[SkipVought]

I guess I'd try inserting ScreenUpdating = False at the beginning of all my subs.

At the end of my ROPE.
Don't have a clue, COL.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com