No macro has been made for a worksheet. However, when open the worksheet, it
always show the dialog box that it has a macro. How to find out the macro
and delete it?

Hi Janmy,

See Debra Dalgleish's suggestions at:

http://www.contextures.com/xlfaqMac.html#NoMacros


---
Regards,
Norman



"Janmy" wrote in message
...
No macro has been made for a worksheet. However, when open the worksheet,
it
always show the dialog box that it has a macro. How to find out the macro
and delete it?

you may find that thare's code behind a sheet or a module - look in the IDE
, select each worksheet and check its code page.
If there are any modules, again, check if there's any code. If a module has
no code, delete it.

"Janmy" wrote:

No macro has been made for a worksheet. However, when open the worksheet, it
always show the dialog box that it has a macro. How to find out the macro
and delete it?

How to find the code?

"Patrick Molloy" wrote:

you may find that thare's code behind a sheet or a module - look in the IDE
, select each worksheet and check its code page.
If there are any modules, again, check if there's any code. If a module has
no code, delete it.

"Janmy" wrote:

No macro has been made for a worksheet. However, when open the worksheet, it
always show the dialog box that it has a macro. How to find out the macro
and delete it?