If you can't find them and they aren't needed, try making a new workbook and copying all of the 10 worksheets 1 by 1 to it. Good change the new worksheet won't give that message.
If it only does after copying, say, worksheet #6, you know that somehow that's special. Then experiment further. In stead of copying the worksheet, for example, you could copy the contents to an empty worksheet. That might make a difference.
Kees
Hi, I have Excel97 (yes I know it's old). I have a worksheet that when I open it it says the workbook you are opening contains macros and asks to disable or enable Macros. I don't think there are any macros in it. I don't even know how to make a macro. How can I find it/them and delete them? I alway say disable. This workbook has 10 worksheets in it. I went to Tools-Macros but it didn't show any.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic