I've deleted all macros but still asked when opening file
 

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

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

I've deleted all macros but still asked when opening file
 

I followed your directions and didn't see any option to delete macros.

In any event, you need to delete all code and all modules. That can only be
done in the VBE.

--
Regards,
Tom Ogilvy



"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

I've deleted all macros but still asked when opening file
 

Macros in personal.xls would not cause the disable macro prompt when you are
opening another workbook.

--
Regards,
Tom Ogilvy


"Brian K. Sheperd" wrote in message
...
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

I've deleted all macros but still asked when opening file
 

as Tom said, "delete all modules" or REMOVE

--
Don Guillett
SalesAid Software

"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

I've deleted all macros but still asked when opening file
 

Don't forget to delete code from the Excel objects (Sheets and
ThisWorkbook)

Cheers.

- Luther