| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Check for password protection
DUHH ain't I the dummie
Thanks Curt "Norman Jones" wrote: Hi Curt, After protecting the project, to activate the protection, save the workbook, close and re-open Excel. --- Regards, Norman "Curt" wrote in message ... I went into vba propertiers and password protected. Still after f8 puts you right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
| Reply |
| 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 | |||
Hybrid Mode
