I need to set a "password" and "lock project for viewing" using excel vb code. I know that the following code prevents a user from making any changes to the spreadsheets:
xlBook.Protect Password:="Password" but I need to prevent a user from viewing and making changes to the code.
Thanks for any help.
TW
xlBook.Protect Password:="Password" but I need to prevent a user from viewing and making changes to the code.
Thanks for any help.
TW