Forum Home
Press F1
Thread ID: 16665	2002-03-14 09:05:00	How do you get rid of Excel macros?	Guest (0)	Press F1

Post ID	Timestamp	Content	User
39153	2002-03-14 09:05:00	At work we've got a number of Excel 97 workbooks that I once made (different) macros for, but which we no longer use. The trouble is that even though the macros were deleted from the workbook we still get the message 'do we want to enable macros or not?'. How can I get rid of this message, or delete the macros properly if they are still there? I don't know VB, nor a heck of a lot about macros - I wish I had never touched them now!	Guest (0)
39154	2002-03-14 09:35:00	Hi Susan Hopefully someone will come up with a proper answer for you, but if not, you can just disable the warning: Tools > Macro > Security > Security Level tab > Choose 'Low'. Naturally this has its risks - do spreadsheets come in from outside the organisation? If so, do you all have frequently updated virus protection? Actually, another thing that occurs to me as I write this: Do you have 'add ins' installed? I think some of them are probably macros and might trip the detector (just a thought). Cheers John.	Guest (0)
39155	2002-03-14 21:16:00	Remember that macro code can lurk in several places on a workbook and you need to empty all of them to get it 'clean'. Open workbook; Press ALT/F11 to get to Macro editor; You should be able see a list of currently open books etc If not try using View... Project Explorer...; Find your workbook and expand its list - hit the [+] - this should show a list of sheets and modules; Double click on each item in turn and check that it has no code associated; For modules you can right click on the module name and then choose Remove module_name... At the end you should go back to the excel view and do a SaveAs... with a new name so that you retain the old version (just in case :-) have fun Have fun	Guest (0)
39156	2002-03-15 01:40:00	Thanks for that info JT, I did what you said and in one workbook it had six empty modules, which I deleted. The macro warning didn't return after that. In another workbook it had the following code in a couple of the sheets: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub That may mean something to you, but I don't know what it does and as far as I'm aware no one uses any macros in that workbook, so I deleted that text. Once again the macro warning was eliminated. Now I'm keeping my fingers crossed that I don't soon get a nasty surprise! LOL By the way, I have noticed that you appear to have a good knowledge of Excel, so I was wondering if you would mind helping with another query I've got? I have to think a bit how to describe it first, but if you'd like to help should I post it here or in a new thread? Many thanks for your help so far!	Guest (0)
1