ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I find a macro in a worksheet? (https://www.excelbanter.com/excel-worksheet-functions/114341-how-do-i-find-macro-worksheet.html)

JHJ

How do I find a macro in a worksheet?
 
Excel 2002 SP3
When I open a worksheet, I get a pop-up that says that the worksheet
contains macros. I never created macros in that worksheet. "Tools", "Macros"
doesn't list any.

How can I find the macro that's causing that warning?

Thanx, John J.

Bob Phillips

How do I find a macro in a worksheet?
 
See http://www.contextures.com/xlfaqMac.html#NoMacros, this describes all
places macros can 'hide'

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JHJ" wrote in message
...
Excel 2002 SP3
When I open a worksheet, I get a pop-up that says that the worksheet
contains macros. I never created macros in that worksheet. "Tools",

"Macros"
doesn't list any.

How can I find the macro that's causing that warning?

Thanx, John J.




JHJ

How do I find a macro in a worksheet?
 
Thanks, Bob. That did it !

Regards,
John J.

"Bob Phillips" wrote:

See http://www.contextures.com/xlfaqMac.html#NoMacros, this describes all
places macros can 'hide'

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JHJ" wrote in message
...
Excel 2002 SP3
When I open a worksheet, I get a pop-up that says that the worksheet
contains macros. I never created macros in that worksheet. "Tools",

"Macros"
doesn't list any.

How can I find the macro that's causing that warning?

Thanx, John J.






All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com