save as event
 

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.

save as event
 

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"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"scrabtree23" wrote in message
...
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.