A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions would be greatly appreciated !
Thanks!
Jugglertwo

For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.

If after selecting A1:C10, you press F5 Special Visible cells only OK
and then do the copy paste, only the visible cells get copied/pasted
(the hidden B1:B10 won't be appear in the paste)

But why not just cut col B and paste it in a safe, far away col to the
right, say in col X, and then hide col X ? This might be a simpler way to do
it ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jugglertwo" wrote in message
...
A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions would be greatly appreciated !
Thanks!
Jugglertwo

And just to add to Max's "move the column elsewhere" suggestion...

Make sure you tell the students that excel's protection of worksheets and
workbooks (under tools|Protect) is easily broken. It shouldn't be use to keep
private information private.

It's really meant to keep users from making simple mistakes (overwriting
formulas/values that shouldn't change).



Jugglertwo wrote:

A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions would be greatly appreciated !
Thanks!
Jugglertwo

--

Dave Peterson