You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
I've put in a password using a VBA macro to my excel spreadsheet. No i don't know how to remove this password. Also, the macro i used to apply this password has disappeared.
How do i remove this password so that the file does not ask for it everytime i attempt to open it.
in teh vba editor go to tools VBAProject Properties, then click on the protection tab, un click lock project for viewing, and delete teh password, then save the project