ExcelBanter - "openinf file..."ENABLE MACROS...DISABLE MACROS"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - "openinf file..."ENABLE MACROS...DISABLE MACROS" (https://www.excelbanter.com/excel-discussion-misc-queries/109501-openinf-file-enable-macros-disable-macros.html)

F. Lawrence Kulchar

"openinf file..."ENABLE MACROS...DISABLE MACROS"

How can I get the Enable/Disable macro window to NOT appear each time I open
an Excel file.

I do NOT use macros...therefore, I do not need to see the window...I always
click "disable macros."

Thanks,

FLKulchar

Stefi

"openinf file..."ENABLE MACROS...DISABLE MACROS"

Probably you have some unused modules in your workbook. Remove them!
Alt-F11 (VB Editor)/View/Project Explorer/Modules(under your workbook
name)/Right click on Module1, Module2, .../Remove module

Regards,
Stefi

€žF. Lawrence Kulchar€ ezt Ã*rta:

How can I get the Enable/Disable macro window to NOT appear each time I open
an Excel file.

I do NOT use macros...therefore, I do not need to see the window...I always
click "disable macros."

Thanks,

FLKulchar

F. Lawrence Kulchar

"openinf file..."ENABLE MACROS...DISABLE MACROS"

YOU WERE ABSOLUTELY CORRECT; I followed your instructions...works perfectly.

Thank you,

FLKulchar

"Stefi" wrote:

Probably you have some unused modules in your workbook. Remove them!
Alt-F11 (VB Editor)/View/Project Explorer/Modules(under your workbook
name)/Right click on Module1, Module2, .../Remove module

Regards,
Stefi

€žF. Lawrence Kulchar€ ezt Ã*rta:

How can I get the Enable/Disable macro window to NOT appear each time I open
an Excel file.

I do NOT use macros...therefore, I do not need to see the window...I always
click "disable macros."

Thanks,

FLKulchar

Stefi

"openinf file..."ENABLE MACROS...DISABLE MACROS"

You are welcome! Thanks for the feedback!
Stefi

€žF. Lawrence Kulchar€ ezt Ã*rta:

YOU WERE ABSOLUTELY CORRECT; I followed your instructions...works perfectly.

Thank you,

FLKulchar

"Stefi" wrote:

Probably you have some unused modules in your workbook. Remove them!
Alt-F11 (VB Editor)/View/Project Explorer/Modules(under your workbook
name)/Right click on Module1, Module2, .../Remove module

Regards,
Stefi

€žF. Lawrence Kulchar€ ezt Ã*rta:

How can I get the Enable/Disable macro window to NOT appear each time I open
an Excel file.

I do NOT use macros...therefore, I do not need to see the window...I always
click "disable macros."

Thanks,

FLKulchar

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