Password Protect Hidden Worksheet

  • Thread starter Thread starter ann godoshian
  • Start date Start date
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"
 
You must log in or register to reply here.

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

Expanding beyond "Very Hidden" 1
protecing hidden columns 1
Password prompting to unhide worksheet allows temporary visibility 2
Excel Protection 2
How to retrive password protected worksheet but forgot password? 1
To protect all worksheet simultaneously in a excel workbook 1
How to password Protect when WORKSHEET is Very HIDDEN 5
Excel Office 2007 Password protect worksheet 1

Back
Top