Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enable/Disable macros
My file still asks if I want to enable or disable macros even though I have
deleted all macros. Any Ideas? /Adam |
#2
|
|||
|
|||
Hi Adam,
the reason for this is that although the macros have been deleted a module folder still exists. In the VB editor you will see a module folder. Expand this, then right click on the module shown (probably 'Module1') and choose 'Remove..'. Click 'No' in the next dialog and Save. You won't see the macro dialog when you re-open the file. Regards, TonyM -----Original Message----- My file still asks if I want to enable or disable macros even though I have deleted all macros. Any Ideas? /Adam . |
#3
|
|||
|
|||
Adam,
You could run this code on the workbook Dim vbMod As Object For Each vbMod In ActiveWorkbook.VBProject.VBComponents Select Case vbMod.Type Case 1, 2, 3: 'module, class, userform ThisWorkbook.VBProject.VBComponents.remove vbMod Case Else 'ThisWorkbook, sheet modules With vbMod.CodeModule .DeleteLines 1, .CountOfLines End With End Select Next vbMod Make sure that you don't leave it in the workbook though :-) -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Hi Adam, the reason for this is that although the macros have been deleted a module folder still exists. In the VB editor you will see a module folder. Expand this, then right click on the module shown (probably 'Module1') and choose 'Remove..'. Click 'No' in the next dialog and Save. You won't see the macro dialog when you re-open the file. Regards, TonyM -----Original Message----- My file still asks if I want to enable or disable macros even though I have deleted all macros. Any Ideas? /Adam . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Enable/Disable Macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |