+ Reply to Thread
Results 1 to 2 of 2

"running" page

  1. #1
    Chaz
    Guest

    "running" page

    I have a spreadsheet with a fairly complex series of macros that create
    reports. These macros take several seconds to run and pull data from several
    sheets. Is there a way to mask that process from the user with a page that
    shows while the macros are running rather than seeing the data being
    filtered, sheets being added etc ?

    Thanks in advance,
    Chaz

  2. #2
    Ron de Bruin
    Guest

    Re: "running" page

    Hi Chaz

    Use this in your code so the user don't see your macro working
    You can select a sheet first with a nice picture or text before you set ScreenUpdating to false

    Application.ScreenUpdating = False

    'your code

    Application.ScreenUpdating = True

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Chaz" <Chaz@discussions.microsoft.com> wrote in message news:FD088171-109D-46BA-98E4-449CBE78070D@microsoft.com...
    >I have a spreadsheet with a fairly complex series of macros that create
    > reports. These macros take several seconds to run and pull data from several
    > sheets. Is there a way to mask that process from the user with a page that
    > shows while the macros are running rather than seeing the data being
    > filtered, sheets being added etc ?
    >
    > Thanks in advance,
    > Chaz




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1