Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Password Protection for Excel
I would like to know if there is some where in the Excel
object model where I can password protect a file through automation? I can't use the "save as" function. I want to be able to do it another way without the saving feature because my app does the saving automatically and I can't change the way it functions. But I can use VBscript to change the file. Thanks Jerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Password Protection for Excel
Jerry wrote:
I would like to know if there is some where in the Excel object model where I can password protect a file through automation? I can't use the "save as" function. I think you will have to use the Save As function to apply a password to be used on opening the file. Has the file already been saved? If so you can Save As the same name again, specifying the password Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
use a macro to automate excel worksheet password protection | Excel Discussion (Misc queries) | |||
Password protection in Excel | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
Automate differente excel versions + VBA protection | Excel Programming |