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?

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)



"older pro" wrote in message
...
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?

See (3/4 down on the web page)
Deleting All VBA Code In A Project
http://www.cpearson.com/excel/vbe.htm


---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote in message ...
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)



"older pro" wrote in message
...
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?

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.

"older pro" wrote:

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?

Thank you, thank you. Another "pain" removed.


"older pro" wrote:

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?