Navigate to next or previous posts:

« Hasbrouck on RFID Passports | Emergent Chaos Main page | Ameritrade, 200,000 SSNs, Backup Tape »

Removing Excel Macros?

(Posted by adam)

excel.jpg I have a document where I started to create a macro, then realized that some clever search and replace would work. So I stopped creating the macro. But now, the document (which I share with others) has a macro in it. Sure, its possible to open with macros disabled, but I'd like to remove the thing, so that I don't contribute to dialog-box numbness and errors.

Is there a way to remove a macro from a document using Excel X for Mac?

Posted by adam on April 19, 2005 at 1:02 PM in information security . You can: comment, view comments (5), see trackbacks (0) or search Technorati.

Bookmark this post:

Comments

You should be able to do it with the macro editor. Failing that, copy the entire spreadsheet and paste it into a new one.

Posted by: Simson L. Garfinkel | April 20, 2005 2:09 AM

Under Tools menu, Macros |> Macros... there's a delete function, but it only works if macros are enabled. Seems to me that I should be able to delete a macro when they're disabled.

Posted by: Adam | April 20, 2005 3:47 PM

So having done that, the macro warning pops up, and there are no macros that I can find. hmmm.

Posted by: Adam | April 20, 2005 3:54 PM

This is what stops Excel assuming there are macros in the worksheet: Go to Tools menu, Macro, Visual Basic Editor. In "Projects" window Ctrl-click "Module1" of the worksheet, choose Remove Module1..., and answer Yes. Press Apple-Q to return to the worksheet and save it.

Posted by: Orvo Miettinen | April 26, 2005 4:08 AM

Thanks, Orvo, that works! Let me add that "remove module" is under the file menu, and that you need to quit the Visual Basic editor to return to Excel (which I found sort of non-intuitive.)

Adam

Posted by: Adam | April 26, 2005 1:29 PM