![]() |
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 |
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 |
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