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 |
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 |
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