A Andy Wiggins Dec 15, 2003 #2 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 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"
