Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2013
Excel 2013
Excel 2013 developer reference
Object model
Workbook Object
Properties
AccuracyVersion Property
ActiveChart Property
ActiveSheet Property
ActiveSlicer Property
Application Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
BuiltinDocumentProperties Property
CalculationVersion Property
CaseSensitive Property
ChangeHistoryDuration Property
ChartDataPointTrack Property
Charts Property
CheckCompatibility Property
CodeName Property
Colors Property
CommandBars Property
ConflictResolution Property
Connections Property
ConnectionsDisabled Property
Container Property
ContentTypeProperties Property
CreateBackup Property
Creator Property
CustomDocumentProperties Property
CustomViews Property
CustomXMLParts Property
Date1904 Property
DefaultPivotTableStyle Property
DefaultSlicerStyle Property
DefaultTableStyle Property
DefaultTimelineStyle Property
DisplayDrawingObjects Property
DisplayInkComments Property
DocumentInspectors Property
DocumentLibraryVersions Property
DoNotPromptForConvert Property
EnableAutoRecover Property
EncryptionProvider Property
EnvelopeVisible Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
Excel8CompatibilityMode Property
FileFormat Property
Final Property
ForceFullCalculation Property
FullName Property
FullNameURLEncoded Property
HasPassword Property
HasVBProject Property
HighlightChangesOnScreen Property
IconSets Property
InactiveListBorderVisible Property
IsAddin Property
IsInplace Property
KeepChangeHistory Property
ListChangesOnNewSheet Property
Mailer Property
Model Property
MultiUserEditing Property
Name Property
Names Property
Parent Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
PivotTables Property
PrecisionAsDisplayed Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
ReadOnly Property
ReadOnlyRecommended Property
RemovePersonalInformation Property
Research Property
RevisionNumber Property
Saved Property
SaveLinkValues Property
ServerPolicy Property
ServerViewableItems Property
SharedWorkspace Property
Sheets Property
ShowConflictHistory Property
ShowPivotChartActiveFields Property
ShowPivotTableFieldList Property
Signatures Property
SlicerCaches Property
SmartDocument Property
Styles Property
Sync Property
TableStyles Property
TemplateRemoveExtData Property
Theme Property
UpdateLinks Property
UpdateRemoteReferences Property
UserStatus Property
UseWholeCellCriteria Property
UseWildcards Property
VBASigned Property
VBProject Property
WebOptions Property
Windows Property
Worksheets Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
XmlMaps Property
XmlNamespaces Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Workbook.ReadOnly Property (Excel)

Office 2013

Published: July 16, 2012

Returns True if the object has been opened as read-only. Read-only Boolean.

expression .ReadOnly

expression A variable that represents a Workbook object.

If the active workbook is read-only, this example saves it as Newfile.xls.

VBA
Copy 
If ActiveWorkbook.ReadOnly Then 
 ActiveWorkbook.SaveAs fileName:="NEWFILE.XLS" 
End If
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.