Forum Home
Press F1
 
Thread ID: 62629 2005-10-14 04:55:00 Excel macros bpt2 (6653) Press F1
Post ID Timestamp Content User
396020 2005-10-14 04:55:00 I have an excel spreadhseet with a number of sheets that used to contain some macros. Every time I go to open the file I get the option to enable or disable macros, but there are no longer any in the macros list. What's going on and how do I clear this file of any previous macros? bpt2 (6653)
396021 2005-10-14 07:29:00 Just an idea but you may have a hidden Personal.xls type file in a directory configured in Tools Options General as the Option "At Startup, open all files in:".

You can check this by using the Window Unhide option to open the hidden file or just using the Tools Macro Macroes option and see if any macroes from files other than the 1 you opened are displayed in the list.

If you are happy for this hidden file to Open each time you start Excel you can remove the startup message you are getting by selevting the Tools, Macro Security option and setting it to low if you are confident that any spreadsheets you open do not have any malicious macro's in them
TeejayR (4271)
1