Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hello

    I have created a Macro by accident and I don't need any macros. I have deleted all macros, but after saving the file and reopening it, the dialog message asking me if I want to enable macros appears. I have selected enable, and when I try again to delete all macros, none show up. So how do I get rid of them, so that darn message about macros and viruses won't scare people when they open it. Hope this makes sense. Thanks.
    Time can fix anything.....even a broken clock. - Handy Andy

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HandyAndy' post='768810' date='02-Apr-2009 09:44']Hello

    I have created a Macro by accident and I don't need any macros. I have deleted all macros, but after saving the file and reopening it, the dialog message asking me if I want to enable macros appears. I have selected enable, and when I try again to delete all macros, none show up. So how do I get rid of them, so that darn message about macros and viruses won't scare people when they open it. Hope this makes sense. Thanks.[/quote]
    The module the macros were stored in is still being detected.

    From the VBA explorer window, right click the module and select Remove Module xx

    [attachment=83188:x.gif]

    You will ask if you want to export it before deleting - if you don't, select No.
    Attached Images Attached Images
    • File Type: gif x.gif (9.8 KB, 4 views)

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='Leif' post='768811' date='02-Apr-2009 04:53']The module the macros were stored in is still being detected.

    From the VBA explorer window, right click the module and select Remove Module xx

    [attachment=83188:x.gif]

    You will ask if you want to export it before deleting - if you don't, select No.[/quote]

    Thanks, but it still thinks there is a macro.
    Time can fix anything.....even a broken clock. - Handy Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Could you attach a copy of the workbook? You can delete or alter the data from the worksheets.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Here it is Hans...
    Attached Files Attached Files
    Time can fix anything.....even a broken clock. - Handy Andy

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HandyAndy' post='768813' date='02-Apr-2009 10:05']Thanks, but it still thinks there is a macro.[/quote]
    You can also check the other suggestions in Post 706439 and replies - otherwise upload a copy for Hans to sort

  7. #7
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='Leif' post='768816' date='02-Apr-2009 05:09']You can also check the other suggestions in Post 706439 and replies - otherwise upload a copy for Hans to sort [/quote]

    Thanks Leif, I still had to remove the code from the sheet.
    Time can fix anything.....even a broken clock. - Handy Andy

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Sheet1 has the remnants of a macro:

    Code:
    Private Sub CommandButton1_Click()
    
    End Sub
    Which you can delete...

    Steve

Posting Permissions

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