Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No macros?! (2003)

    The attached workbook doesn't contain any macros, yet when I open it (with macro security set to medium), I'm told otherwise. Any idea where the secret macros are?

    (The workbook is actually produced not by me but automatically by Oracle Discoverer, if that's a clue).
    Waggers
    If at first you do succeed, you've probably missed something.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: No macros?! (2003)

    The workbook contains an invisble macro worksheet (with Excel 4.0 macros, not VBA)

    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type Sheets(2).Visible = True and press Enter.
    - Switch to Excel, you can now see and delete the macro sheet.

    There is a series of defined names that refers to the Macro1 sheet, see Insert | Name | Define.

  3. #3
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    thanks

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> <img src=/S/hansv.gif border=0 alt=HansV width=27 height=26>
    Thanks Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

Posting Permissions

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