ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protecting a file (https://www.excelbanter.com/excel-programming/428330-protecting-file.html)

edward

protecting a file
 
Hi everybody,
I've written some VBA code to send certain data to an Excel file which
somewhere in our network, I deally I want to make the file Read/write
protected and only accessable through VBA . Something like remove read only
property anytime I want to send a new record to Excel and after I finish the
process then make it read only again.
What is the best way of doing this?
--
Best regards,
Edward


All times are GMT +1. The time now is 01:34 PM.

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