How to make xl readonly true or false on cond

Govind - Mar 8, 2011 at 10:57 PM
 Govind - Mar 9, 2011 at 04:58 AM

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.



2 responses

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 9, 2011 at 02:41 AM
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