Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ignore Events Command (97 SR2)

    So, I can use an 'Application.IgnoreRemoteRequests = True' statement at startup for my spreadsheet so that when the user attempts to open another excel file, it's routed to a new instance of Excel. However, if this command is not closed, Excel will not open any files. Is there a way to apply this command only if another workbook is opened?

    Somehow, I would like my workbook to be smart, identifying that another spreadsheet is being opened, intercepting it, and diverting it to it's own instance of Excel. Any ideas how this might be done?

    Because I am employing userforms in my spreadsheet, there are problems with other spreadsheets opening in the same instance.

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Ignore Events Command (97 SR2)

    DrkRealm

    I always thought that while the code is running the User can't open a workbook. But again I am only human.

    I suggest you look into Application.Interactive = False . In the OLH it says that "If you set the this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Blocking user input will prevent the user from interfering with the macro as it moves or activates Microsoft Excel objects. Read/write Boolean.

    Remarks

    This property is useful if you're using DDE, AppleEvents, or OLE Automation to communicate with Microsoft Excel from another application.
    If you set this property to False, don't forget to set it back to True. Microsoft Excel won't automatically set this property back to True when your macro stops running."

    I hope this helps.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ignore Events Command (97 SR2)

    This is something that you can do with an application event. It is possible to create this so that every time the user opens another workbook, some code is fired. See e.g. <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=21126&Search= true&Forum=xl&Words=AppEvent&Match=And&Searchpage= 0&Limit=10&Old=allposts&Main=18503>this thread</A>.

Posting Permissions

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