Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Disabling Macros

Apr 2, 2010 5:16PM PDT

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.

Discussion is locked

- Collapse -
Re: macro's
Apr 3, 2010 12:02AM PDT

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

- Collapse -
If you are sure
Apr 3, 2010 12:03AM PDT

that this workbook is from a reputable source, then the next time you open it click Enable, then check for Macros.

Mark

- Collapse -
A reputable source?!
Apr 3, 2010 1:58AM PDT

I MADE IT.

- Collapse -
Wish I could edit my reply....
Apr 3, 2010 2:00AM PDT

Just wanted to add....

I guess I'm not reputable. You can't trust anybody anymore.

- Collapse -
LOL!
Apr 3, 2010 4:22AM PDT

Sorry but I had to ask. Spreadsheets are often transmitted around to users, eg by email, and that is when we have to be careful.

In that case I don't know why it is asking for permission to enable macros. Kees probably has the right idea, but also, if you just enable when opening then you can see if any macros are listed.

Mark