How come nobody seems to HELP?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How come nobody seems to HELP?

  1. #1
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook that has a control button
    that opens another workbook. This other
    workbook has forms and macro code behind it
    that works when I open the workbook by itself.

    This is my problem: I want the second workbook only opened when the command button is selected from the first workbook. The command button does open the second workbook but, it does not allow me to select (or move) within this workbook. It sits at the current activecell and makes all changes to that one cell. I though maybe it was the Protection issue, but I've tried that and it doesn't fix anything. Any suggestions????

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I cannot replicate your problem. I open other workbooks with a macro and the macros in the opened files work fine. I am not sure how this problem is occurring.

    Is it possible that your command button is somehow not fully releasing the focus? Possibly try setting the TakeFocus******* property to false.

    HTH,
    Jay

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    maybe the property "TakeFocus*******" for your commandbutton is set to "True." Try changing it to false to see if this helps.



    just a couple of suggestions--(no offense intended)--you already posed this question in a previous post, and someone replied to that post before you posted this one...no need to repost the same question as a new thread...just continue from that one. Also, please be more patient; everyone here gives of their time and help freely. If help comes, then good; if not, then it's not good manners to complain or demand. Thank you.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com