Prevent unhide of rows/columns w/out worksheet protection?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I want to have one row and two columns hidden in a worksheet. The thing is,
i dont want the user to be able to unhide them. Using worksheet protection
isn't suitable for the use of this particular worksheet. Is there some vba
that will prevent the user from unhiding them?
Thank you :)
 
If it's really sensitive data, then the user could disable macros and even
unprotect the worksheet (if you chose to use that).

Excel isn't really meant for this kind of security.

If it's not sensitive, you could just rehide those columns/rows whenever the
user changed selection (but they would be able to see it if they really wanted).
 
Hello,
I want to have one row and two columns hidden in a worksheet. The thing is,
i dont want the user to be able to unhide them. Using worksheet protection
isn't suitable for the use of this particular worksheet. Is there some vba
that will prevent the user from unhiding them?
Thank you :)
Click to expand...


An option would be to move the hidden columns to a separate protected
workbook and link to it.

Don S
 
Back
Top