disallow unhide using copy/paste

[ek]

to unhide a column, password is required if sheet is protected. if use save as, to unhide the column password is required, this is not the case for copy paste as to unhide, password not required. how to solve this problem

 

[JE McGimpsey]

There are various techniques you can use to try to bypass copy and
paste, but they probably won't give you the security you want.

Bypassing the worksheet password is a matter of a few seconds work for
anyone who's interested enough to, say, find and read these newsgroups,
since macros and links to add-ins that break worksheet protection are
posted daily. See

http://www.mcgimpsey.com/excel/removepwords.html

for an explanation of why worksheet protection is only protection
against inadvertent changes, not security.

If you want to try to prevent copying and pasting, look through the
archives:

http://groups.google.com/advanced_group_search?q=group:*excel*