Hi, I am looking to modify this VBA code to include a password-protect upon opening the workbook in Excel 2007. The VBA code doesn't seem to function if I add the password-protect in the standard fashion... Any thoughts??
Thanks! - Reayn
Please Login or Register to view this content.
Last edited by shg; 01-13-2011 at 07:31 PM. Reason: fix closing code tag
EnableOutlining is a worksheet property, not an argument to the Protect method.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Ok, but the code still does not work when a 'password upon opening the workbook' is created.... Help pls - Thanks! Reayn
Open and Modify passwords are different than sheet passwords; you have to provide them when you open the workbook. See Help for the Open method.
Ok, I am still very new to VBA coding and am not sure how to insert it in the code but I would like to have the password 'eb' used to open the workbook. Can you help me with specific instructions or the modified code? - Reayn
i'm pretty newbish but can't you just sayPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks