Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes..provided you have the wb object...
Dim wb as workbook Set wb = ActiveWorkbook If this post helps click Yes --------------- Jacob Skaria "Alberto Ast" wrote: Will the statement read as follows? if wb.ReadOnly then wb.Close False else wb.Close True end if "Peter T" wrote: bReadOnly = wb.ReadOnly where wb refers to the workbook you want to know about Regards, Peter T "Alberto Ast" wrote in message ... If I open a file with macros... it could had been opened as read only or as read/write.... Then how do I check with a macro if it was opened as read only or as read/write? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Read and write an Excel file | Excel Programming | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
Read/Write variables to XML file using VBA | Excel Programming | |||
read only file-need to write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |