Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Check for password protection
I have written code to filesearch and then trawl the workbooks for any comments containing a particular string. However when the code is running, if a sheet is password-protected it prompts. Is there any way of checking to see if a file is PP'd without actually trying to open it and therefore getting prompted? code is as below: Set oBook = oExcel.Workbooks.Open(strWkShtPathAndNme, 0, True) CIA, Matt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Password Protection Bug | Excel Discussion (Misc queries) | |||
PASSWORD PROTECTION | Excel Worksheet Functions | |||
password protection | Excel Programming |