Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Password problem in excel 97
I have a Vba Project written in excel 2000. the properties are protected and locked... I works fine in 2000 and later, when you try to enter it asks for the password... then lets you in upon entry of that password.. but in excel 97 it just says it is locked from viewing.. I have tried unchecking the locked from viewing box and leaving the password... but it still gives me the same... Is the a solution that would make it work as it does in 2000. Thank you Randy -- RANDY IN NC ------------------------------------------------------------------------ RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778 View this thread: http://www.excelforum.com/showthread...hreadid=560425 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Password problem in excel 97
Hi Randy
Unlock your VBA in 2000 (uncheck protection in toolsproperties) and save Open in 97 Protect your VBA in Excel 97 and save You can now unlock it in every version -- Regards Ron de Bruin http://www.rondebruin.nl "RANDY IN NC" wrote in message ... I have a Vba Project written in excel 2000. the properties are protected and locked... I works fine in 2000 and later, when you try to enter it asks for the password... then lets you in upon entry of that password.. but in excel 97 it just says it is locked from viewing.. I have tried unchecking the locked from viewing box and leaving the password... but it still gives me the same... Is the a solution that would make it work as it does in 2000. Thank you Randy -- RANDY IN NC ------------------------------------------------------------------------ RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778 View this thread: http://www.excelforum.com/showthread...hreadid=560425 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protecting an Excel file problem | 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 | |||
Excel 2003 Userinterfaceonly Password Protection Problem | Excel Programming | |||
password problem | Excel Programming | |||
Excel password but cant hide the sheets before entering password | Excel Programming |