Limiting Functions
 

On a userform I am working on... I have a common problem of peopl
cutting and pasteing with causes the borders and shading patterns t
become askewed.

Is their a way that I can make it so the user can only copy and past
special

--
wilro8
-----------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...fo&userid=2693
View this thread: http://www.excelforum.com/showthread.php?threadid=49506

Limiting Functions
 

Hello Wilro85,

It is simple to disable the Paste function in the Edit menu, but quit
another challenge to disable the hot key combination of CTRL + V fo
pasting. To do so would require hooking into the Windows Messagin
System. A daunting task even for advanced programmers. Instead you ma
want to toggle between Protecting and Unprotecting the worksheet. Yo
can then control which cell(s) the user can change.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49506