Re: Can this be done?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Sean,

Thanks for your suggestions.

Unfortunately the workbooks to be consolidated have been already been
distributed and it seems a bit of an overkill to either manually
change the code re the MsgBox or change the code re some sort of
automation.

However your Application.Visible has given me some ideas and l will
play around with that. I may just minimise the window while the macro
is running and then re-instate at the end of the code, although the
purpose of using ScreenUpdating was to gain those extra few seconds in
speed.

Once again thank you for your reponse. If you have any other ideas
they will be gratefully received.

Regards

Michael Beckinsale.

.

Relevant Pages

  • Re: msgbox as a progress indicator...
    ... even with screenupdating turned off. ... open 5 or six workbooks and run this macro: ... Dim bk As Workbook ... > it even would show changes with screen updating off). ...
    (microsoft.public.excel.programming)
  • Re: Overriding ScreenUpdate function
    ... This will disable temporarily the Workbook_Open sub. ... Unfortunately the workbooks that I'm copying ... do you know of a way to always keep the master ... ScreenUpdating command in the calling routine and remove it from all the ...
    (microsoft.public.excel.programming)
  • Re: Overriding ScreenUpdate function
    ... This will disable temporarily the Workbook_Open sub. ... Unfortunately the workbooks that I'm copying ... do you know of a way to always keep the master ... ScreenUpdating command in the calling routine and remove it from all the ...
    (microsoft.public.excel.programming)
  • Re: Is IBM actually doing something with IDS?
    ... What has that harmless statement done to you to gain your wrath? ... It's a manifestation of overkill, where people keep coming up with more ...
    (comp.databases.informix)
  • Re: ScreenUpdating "peephole"
    ... ScreenUpdating is a global setting. ... all workbooks. ... cells but one. ... > And then have ActiveCell in another workbook ... ...
    (microsoft.public.excel.programming)