+ Reply to Thread
Results 1 to 6 of 6

Command Button That Opens Existing Worksheet In New Window

  1. #1
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Question Command Button That Opens Existing Worksheet In New Window

    Hello Again!!

    First off, my thanks again to everyone, and I am sorry if I am becoming a bit of a nuisance with all my questions. This has been a huge project thrown at me, but thankfully I am almost done. I al self taught at all of this, and trying to learn as I go. I do try searching the forum and Google for the answer, and only post my questions when I am stumpted for finding an answer. I truly appreciate all the help I've gotten over the last couple of weeks - many of yo have been absolute lifesavers, solving issues in minutes that I have spent hours trying to hack my way through.

    :D

    On to my question. The way my tool has been built is that there are 8 tabs - Sheet1 has only a single Command Button that opens up a Form where all the meat and potatoes are, and the remaining 7 tabs have infomation on my clients - names and contact info, inventory and pricing info, etc.

    What I am trying to do now is add a Command Button on the user form that will open up the corosponding Clients tab in a new window when clicked. So, something along these lines:
    Please Login or Register  to view this content.
    I do already have a variable called Client that captures the name of the Client I am working with.

    Thank you again for all the help!!
    Last edited by nevi; 05-06-2012 at 03:41 AM.

  2. #2
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Re: Command Button That Opens Existing Worksheet In New Window

    I came across this bit... It works to display the tab, but it doesn't open it in a new window...

    Please Login or Register  to view this content.
    There are two reasons I am looking for it to open in a new window. First off, it is so the User Form where all the action is happening can be viewed at the same time as the Client Data, and secondly so the person using the tool can modify that Client Data without inmpacting the data that is feeding / populating the User Form.

    Hopefully that makes sense?

  3. #3
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Re: Command Button That Opens Existing Worksheet In New Window

    Anyone have any ideas on this one? I am not having luck finding an answer...

  4. #4
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Re: Command Button That Opens Existing Worksheet In New Window

    I've noticed this has been looked at quite a bit, but no response. Should I take that to mean this isn't possible?

    That is not a complaint on your response time - just a question. You guys are always so super helpful!

  5. #5
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Re: Command Button That Opens Existing Worksheet In New Window

    I think I have this figured out!! Just one thing I can't get...

    This is what I have so far:
    Please Login or Register  to view this content.
    Now, this is working to open the requested WorkSheet in a new window. The part I can't figure out is how to make that windown pop up on the screen - it opens it already minimized. Additionally, when you do click on it in the TaskBar and open it manually the User Form still shows up on top of it...

    Thanx again for all the help!

  6. #6
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    Re: Command Button That Opens Existing Worksheet In New Window

    Okay, made some more progress but really need some help here... The below code works to open up a new Excel Window overtop the User Form, but it is blank - the WorkSheet still opens in a third seperate window, minimized and with the User Form docked overtop of it...

    Please Login or Register  to view this content.

+ 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