ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hidden macros? (https://www.excelbanter.com/excel-programming/370015-hidden-macros.html)

Dave F

hidden macros?
 
I just opened a workbook which claims to have macros, but I can't find any
code. Is there a way to unhide the macros and/or code?

Tom Ogilvy

hidden macros?
 
Assuming this is a recently created workbook -

If you have any modules in the workbook, even if they are empty, they would
cause that message. Delete any modules shown in the project explorer

Another place would be the thisworkbook module and modules associated with
each sheet.

go to each, click in it, do Ctrl+A, hit delete, close it.

then save the workbook.

--
Regards,
Tom Ogilvy


"Dave F" wrote:

I just opened a workbook which claims to have macros, but I can't find any
code. Is there a way to unhide the macros and/or code?



All times are GMT +1. The time now is 05:17 AM.

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