Hello, I have a macro that writes to an Excel Spreadsheet and then saves it. However, when the spreadsheet is open a Save As window appears when it first wants to save. But after that, it doesn't appear again. Is there a way to make sure that the Save As window doesn't even appear the first time?
P.S. I already know about DisplayAlerts.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.