I have a template which has a toolbar button. The buton was assigned macro to
macro - SaveToDrive.
The save macro uses cell A12 to saveas name.
This is a template so each new instance of the xls is blank.
On first i enter 'BJS1' in A12 and the run macro, saves as A12.xls to my c:
drive and closes.
If I delete BJS1.xls and open new and enter 'BJS2' in A12 and save I get
message
'BJS1.xls' could not be found.
If I then open the template and look to see macro assigned to button it has
'BJS1.xls' assigned and not 'SaveTo Drive'.

The template save is written like this:
sFilename = "c:" + strcell"
ActiveWorkbook.SaveAs Filename:=sFilename, _
FileFormat:=xlNormal, _
ReadOnlyRecommended:=False, _
CreateBackup:=False

Application.Quit
Application.StatusBar = "Application Closing."

Am I missing something on the save or am I doing something wrong in
assigning the macro.
I am protecting the sheet and the workbook.
Thanks,
Bryan