Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Prevent unhide of rows/columns w/out worksheet protection?
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 :) |
#2
|
|||
|
|||
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). annonymous wrote: 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 :) -- Dave Peterson |
#3
|
|||
|
|||
On Thu, 10 Mar 2005 08:35:13 -0800, "annonymous"
wrote: 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 :) An option would be to move the hidden columns to a separate protected workbook and link to it. Don S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide more than one worksheet at a time | Excel Discussion (Misc queries) | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I unhide rows 1 through 28 on an Excel worksheet? | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |