How to make xl readonly true or false on cond

Solved/Closed
Govind - 8 Mar 2011 à 22:57
 Govind - 9 Mar 2011 à 04:58
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



Related:

2 responses

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