Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    Excel 2007, SP1
    Create a workbook with two sheets. Put a button (Forms Control) on one of the sheets, and assign it to a subroutine in a regular VBA module (e.g., MsgBox "Hello").
    Then move the second sheet to another workbook.
    If you then press the button, it fails because it is now pointed to the other workbook.
    Is this a known bug? I looked in the Microsoft Knowledge Base but couldn't find anything (but it's hard to know what to search on).
    I uploaded an example if it helps...
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't have 2007, but I don't see the problem in 2003.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I'm pretty sure I've seen something similar posted in the MVP newsgroups (in which case I assume it's been reported officially) but I don't see it in the MSKB yet.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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