View Full Version : How do you hide AND protect an excel sheet
2011-10-31, 08:21 PM
I have two sheets i want to not only hide but require a password to view. how is this done?:confused2:
2011-11-01, 11:18 PM
Well... you can't exactly do that through the standard user interface
You could do this though:
Hide all the rows except row 1
Hide all the columns except A
Protect the worksheet
This would force someone to unprotect it before they could unhide the rows and columns.
To request a password to unhide and view a worksheet all in one go, you'd need to resort to VBA code. (We can help you with this, and it's built into Excel.)
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.