My PC seems to have developed a strange habit that I cannot seem to stop.
I am using Excel 2000 and if I open a file from the recently-used list (under the File menu), I am prompted with the usual "Do you want to disable / enable macros" dialog box, and if I choose "enable", it does just that.
But if I open a file using File, Open then browse, it just opens the file and automatically disables the macros without asking. (If I then close the file and call the same one up from the recently-used list, it asks!)
Is there a check box somewhere that I have missed that controls this, or is it a more serious problem?
Thanks for any suggestions,
DuckBill
I am using Excel 2000 and if I open a file from the recently-used list (under the File menu), I am prompted with the usual "Do you want to disable / enable macros" dialog box, and if I choose "enable", it does just that.
But if I open a file using File, Open then browse, it just opens the file and automatically disables the macros without asking. (If I then close the file and call the same one up from the recently-used list, it asks!)
Is there a check box somewhere that I have missed that controls this, or is it a more serious problem?
Thanks for any suggestions,
DuckBill