Remove Macro Moduel

O

older pro

Trying to eliminate warning box when I open spreadsheet concerning macro.
There are no macros in the form. Have gone to Contextures without
success.Right clicking sheet tab gives me a box with heading of "Text.xls -
Sheet1 (Code). In box are two boxes names "Worksheet" and "Selection
Change." Then Private sub worksheet.....etc. End Sub. Private sub and Ed sub
are in blue. More ideas?
 
B

Bob Phillips

So delete all of that code that you are seeing.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

JLatham

As Bob Phillips has said, delete everything in that module, leaving a clean
sheet.

You cannot delete modules that are attached to the workbook or to worksheets
- they just disappear when you erase all code from them. And as you've seen
if there is even the appearance of some code in them, even an empty shell like
Sub Begin()
End Sub
it will trigger the alert.
 
Top