Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Never say Die' macro(s) (2000 sp-3/ 98SE)

    I am trying to modify a workbook, based on a "legacy" template I think, into a new working .XLT. I've stripped it to the bare bones, even to the extent of deleting all the original worksheets. I've even used Chip Pearson's macro from another workbook to delete all the VBA code, if there was some hiding somewhere. I've looked everywhere I can think of on the interface. Still I'm asked about enabling macros when I open it. I've run out of places to look! If any of the XL detectives can help "rid me of this meddlesome macro(s)" I'd much appreciate.

    Alan

  2. #2
    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

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    Alan,
    There are 2 dialogsheets in the template. Try this:
    <pre>Sub RemoveHiddenSheet()
    Dim sht As Excel.DialogSheet
    Application.DisplayAlerts = False
    For Each sht In ActiveWorkbook.DialogSheets
    sht.Visible = True
    sht.Delete
    Next sht
    Application.DisplayAlerts = True


    End Sub
    </pre>

    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    <P ID="edit" class=small>(Edited by AlanMiller on 21-Sep-05 01:10. Correction - XL5 for Dialog Sheets.)</P>Wow! Thanks Rory. "Legacy" was right by the sounds of it... back to XL4!
    I'll give your code a whirl to try to scrub it clean. BTW, how did you go about discovering their existence?

    Alan

  4. #4
    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

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    Easy - when I tried to disable the macros, I got an error saying that the macros were of a type (Excel 4 or VB) that couldn't be disabled! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    I'm not sure if this is the time for <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15> or <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>. I reckon I tried everything save for the bleedin' obvious of selecting "Disable Macros". It must have seemed somehow counter-intuitive, considering it was macros I was trying to sniff out. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Still, I wouldn't have known where to look anyway, even after twigging to ancient XL artifacts in the mix. Many thanks... headache now all but gone.

    Alan

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    If you have your security level set to at least medium, you will get that message automatically when you open the workbook. You are really living dangerously if you have it set to low.
    Legare Coleman

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Never say Die' macro(s) (2000 sp-3/ 98SE)

    No arguments there Legare. In this case though, the best I could do was to rely on the fact that it was from a trusted (client) source and with whatever my AV software came up with.

    Alan

Posting Permissions

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