View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brian K. Sheperd Brian K. Sheperd is offline
external usenet poster
 
Posts: 18
Default I've deleted all macros but still asked when opening file

Mark,

Do you have any macros in your personal.xls file? When you open the macro
window, there is a drop down that shows all open workbooks, this workbook,
and personal.xls. If someone wrote a function, I do not believe that shows
up in the window (just subroutines). You would have to check in the VBA
section (ALT-F11 -- or tools - macros - Visual Basic Editor).

Brian

"Mark" wrote in message
...
I think I've deleted all macros by going to tools- macros - security then
right click and delete so none are left. However when I open the file it
still asks whether I want to enable macros! Please help