Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel READ ONLY batch file processing

28 views
Skip to first unread message

sharon

unread,
Jul 19, 2010, 3:07:27 PM7/19/10
to
Hi,

I have a number of excel files in a folder. I'd like to put these as
READ ONLY only. Is there a macro I can run to automatically put these
as READ ONLY? Or do I have to manually go into each file and save
them as READ ONLY?

An alternative would be to put on a password for modification - users
can open file but not modify it - but I haven't found a code for this
either.

Any suggestions?

Thanks in advance.

0 new messages