Thread
:
Make a file read only
View Single Post
#
1
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Make a file read only
Michael,
You can set the Read-Only attribute with code like the following:
SetAttr "C:\book1.xls", vbReadOnly
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Michael Singmin" wrote in message
...
Hello Group,
I am using Excel 2000.
Can one change the properties of a file (eg. make it read only) via
VBA or by calling some API function ?
Thanks,
Michael Singmin
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson