How to make xl readonly true or false on cond

[Solved/Closed]
Report
-
 Govind -
Hi,

I have an requirement like need to open an excle workbook and make it as readonly false then copy some rows to dat workbook then again make it as readonly true and save it.
Is it possible by using Macros can any body help me please.

Thanks,
Govind



2 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
You can do this without using Macro.

Just protect the worksheet by password and it becomes read only. if you want to edit the sheet unprotect the worksheet and and edditing again protect it.
Thank you for reply ,i got it