| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep a file from opening unless macros are enabled? | Excel Discussion (Misc queries) | |||
| Excel 09 File containing macros is not opening | Excel Discussion (Misc queries) | |||
| enable macros question not being asked when opening file | Excel Discussion (Misc queries) | |||
| Macros Disabled when opening file | Excel Discussion (Misc queries) | |||
| Why do macros show up while opening document, but were deleted? | Excel Discussion (Misc queries) | |||
Hybrid Mode
