Macro for file save as

  • Thread starter Thread starter JoJo
  • Start date Start date
J

JoJo

I have a spreadsheet with formulas in it. When the user opens the worksheet
they are prompted to specify a file for data to import - this all works
fine. Once they import the data I want to "grey out" File Save so they
can't save over the old file and force them to use a File Save As. I've
tried Get File Save As - it brings up the save as screen, but you can't save
anything. The file is created in Excel 97 but could be used by others with
95 or higher. Any simple solutions?

thanks! JoJo
 
Even file Save As allows you to save over the original file.

Sound like you need to make your "template" a real template (XLT file). So
the file is created with File=>New using your template rather than file
open.
 
Back
Top