Disable copy/paste of protected hidden cells?

MartinHK

New Member
Joined
Sep 9, 2008
Messages
9
Hi,

I have a similar problem to one mentioned here:
http://www.mrexcel.com/forum/showthread.php?t=245549

I've drawled through the forum and haven't found an answer and wonder if there have been any developments.

I'm using Excel 2003.

I have a sheet with a range of rows hidden and then locked. The idea is to stop the user seeing inside the hidden cells. This works great within the original WB. However, if you copy the entire sheet and paste into a blank sheet the protection is removed and the hidden cells can be unhidden.

Is there a way round this? Either by menu or VBA?

Thanks in advance

Martin
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top