Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As - Before Save Event, VB, another name | Excel Worksheet Functions | |||
Save Event - Determine if called by code or user | Excel Programming | |||
Macro vs Manual save event | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
After save event | Excel Programming |