Password Protect Hidden Worksheet

A

Andy Wiggins

You can password protect the unhidden worksheet and then hide it.

Or, you can password protect a hidden sheet using VBA with something like:

Sheets("Sheet3").Protect Password:="aaa"

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protecing hidden columns 1
Excel Office 2007 Password protect worksheet 1
Different password for different worksheet 11
How to password Protect when WORKSHEET is Very HIDDEN 5
Can you lock cells so data can't be referenced? 2
Is there a way that I can password protect a worksheet 3
Password prompting to unhide worksheet allows temporary visibility 2
vba solution for protection 3

Top