What I want it to do when I click on save is to have it open the Save As box and My Documents is the default folder so that all I have to do is rename the file and click save. But I still need to have the blank excel file stay on the desktop ready for the next time I need to enter data.
I know this can be done because someone else had it set up this way but unfortunately it got deleted. I have tried making the file on the desktop a read only file. When I click save, it gives me a message saying it's read only and I need to save a copy. This would be okay, but when I click to save the copy, it takes me to the Save As box and the default is still the desktop.
This is difficult to explain in print but hopefully it makes enough sense.
If anyone knows how to do this, please reply. Thanks in advance.
By the way, the operating system is Windows XP home and the excel version is 2003.