ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to remove macro as I open worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/209249-how-remove-macro-i-open-worksheet.html)

Eric

How to remove macro as I open worksheet?
 
Does anyone have any suggestions on how to remove macro as I open worksheet?
I have already checked and delete all macro within the spreadsheet, but
whenever I open this worksheet, it requests to run macro message.
Does anyone have any suggestions on how to remove this macro message?
Thanks in advance for any suggestions
Eric

Sheeloo[_3_]

How to remove macro as I open worksheet?
 
Delete the module after opening the VBE.

It might be from personal.xls or an Add-In?
What is the complete message? Disable Add-Ins one by one and see.
Also look in XLSTART folder and remove workbooks/templates from there to
test...

"Eric" wrote:

Does anyone have any suggestions on how to remove macro as I open worksheet?
I have already checked and delete all macro within the spreadsheet, but
whenever I open this worksheet, it requests to run macro message.
Does anyone have any suggestions on how to remove this macro message?
Thanks in advance for any suggestions
Eric


Dave Peterson

How to remove macro as I open worksheet?
 
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Eric wrote:

Does anyone have any suggestions on how to remove macro as I open worksheet?
I have already checked and delete all macro within the spreadsheet, but
whenever I open this worksheet, it requests to run macro message.
Does anyone have any suggestions on how to remove this macro message?
Thanks in advance for any suggestions
Eric


--

Dave Peterson


All times are GMT +1. The time now is 02:07 AM.

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