save as event

  • Thread starter Thread starter scrabtree23
  • Start date Start date
S

scrabtree23

Here is a code

If ThisWorkbook <> "Time Form" Then
ThisWorkbook.Name = "Time Form"
End If

I get an error that I can not do this on a read only
something.
 
The Name property is read-only, and the only way to change it is to save the
workbook under a new name using SaveAs. E.g.,

ThisWorkbook.SaveAs Filename:="TimeForm.xls"
 
Back
Top