View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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