View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George Raymond George Raymond is offline
external usenet poster
 
Posts: 3
Default Disable the Edit menu command 'Paste Special'

Is there a way to disable the Edit menu command "Paste
Special" while users opening and using a workbook I
supply? And then enable the command back again on exit?

I tried to do it by adding two events
Delete the command from the Edit menu with a Private Sub
Workbook-Open() event and Add the command back using the
Workbook-BeforeClose event. However, that is not very
useful because the user simply use the Customize option to
add 'Paste Special' back and use it. It defeats the
purpose.

Please help!

George