ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sheet shows macros embedded but none are in VB editor (https://www.excelbanter.com/excel-programming/390893-sheet-shows-macros-embedded-but-none-vbulletin-editor.html)

Clayman

Sheet shows macros embedded but none are in VB editor
 
When I pull up a sheet it warns me that the sheet has macros embedded. I have
gone through the editor (Shift-F11) looking for these macros but cannot find
them. I know there is one that does some 'magic' according to the clients
I've interviewed, and would like to review the code. Where else should I be
looking?

Thank you.
--
Adios,
Clay Harryman

PCLIVE

Sheet shows macros embedded but none are in VB editor
 
Alt+F11

If you see "Modules" in your VBAProject(<Your Workbook.xls), then you'll
need to remove it. Right-click and remove.

HTH,
Paul

"Clayman" wrote in message
...
When I pull up a sheet it warns me that the sheet has macros embedded. I
have
gone through the editor (Shift-F11) looking for these macros but cannot
find
them. I know there is one that does some 'magic' according to the clients
I've interviewed, and would like to review the code. Where else should I
be
looking?

Thank you.
--
Adios,
Clay Harryman




Clayman

Sheet shows macros embedded but none are in VB editor
 
Thank you! That solved the problem. Ya learn something new every day!
--
Adios,
Clay Harryman


"PCLIVE" wrote:

Alt+F11

If you see "Modules" in your VBAProject(<Your Workbook.xls), then you'll
need to remove it. Right-click and remove.

HTH,
Paul

"Clayman" wrote in message
...
When I pull up a sheet it warns me that the sheet has macros embedded. I
have
gone through the editor (Shift-F11) looking for these macros but cannot
find
them. I know there is one that does some 'magic' according to the clients
I've interviewed, and would like to review the code. Where else should I
be
looking?

Thank you.
--
Adios,
Clay Harryman






All times are GMT +1. The time now is 01:20 AM.

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