Results 1 to 5 of 5
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    macros assigned to shapes (Excel2007)

    In my Excel 2003 workbooks I frequently use a 'hidden overlay' of a textbox (from the Drawing menu) anchored and sized to fit a cell.
    (The textbox has no fill and no lines.)
    I can assign a macro to this textbox.
    When I hover the mouse anywhere in that cell, I get the finger pointer as expected.

    In Excel 2007, it seems you only get the 'finger pointer' if you hover very close to one of the cell edges.
    Is there any way to 'restore' the previous behavior?

    zeddy

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macros assigned to shapes (Excel2007)

    If I add a textbox to cell B3 (without fill and border) to Excel 2007, it works (see screenshot)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: macros assigned to shapes (Excel2007)

    Hi Jan

    It doesn't on mine.

    I have attached a sample with one cell (with textbox line showing)
    (the file extension should be changed to .xlsm - cannot post .xlsm files yet??)
    Does this one behave on your system???

    zeddy

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: macros assigned to shapes (Excel2007)

    Hi Jan

    Please ignore the previous post and attachment.
    I tried to create a simple test in a fresh workbook in Excel2007 and stupidly used a 'rectangle' and not a 'textbox'. duh!

    However, the reason for the post was that my original Excel2003 file has hundreds of these 'overlay textboxes' (working perfectly well in Excel2003) but when loaded into Excel2007 they seem to have been 'converted' to 'rectangles'.
    In fact, the graphics display within Excel2007 is very hit and miss with this particular complex workbook.

    zeddy

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macros assigned to shapes (Excel2007)

    Yes those are the "benefits" of the new graphics engine of Office. It tries to convert existing "old" objects to the new type and seems to fail sometimes.
    If you ask me, MSFT was too quick in releasing Office. I hope SR 1 will be better with this regard.

    You may need to write some code that recreates your textboxes (or whatever type they are <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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