How to make xl readonly true or false on cond

Solved/Closed
Govind - Mar 8, 2011 at 10:57 PM
 Govind - Mar 9, 2011 at 04:58 AM
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

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.
0
Thank you for reply ,i got it
0