ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password protect all files in a folder (https://www.excelbanter.com/excel-programming/436315-password-protect-all-files-folder.html)

BOSS

Password protect all files in a folder
 
Hi,

I wish to develope a code which can go to a folder and password protect all
the files. Is this possible... please advise.

Thx!
Boss

James Igoe

Password protect all files in a folder
 
Yes.

1. You start an excel application object
2. Iterate through directory listing, opening each file
3. setting password-preotection, resaving and closing file
4. opening next

"Boss" wrote:

Hi,

I wish to develope a code which can go to a folder and password protect all
the files. Is this possible... please advise.

Thx!
Boss



All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com