We have several template files that require a date in cell A1 of Sheet1. Is it possible to have VBA include the date based on the computer clock but only one time and that is automatically when the file is opened? The format would be mmmm d, yyyy.
No problem, you said there was something else you wanted to have done, which you wanted to add in the start of code if you were doing this through macro?
what was that?