View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Wazza McG[_2_] Wazza McG[_2_] is offline
external usenet poster
 
Posts: 3
Default Turning off Cut and Copy?

I found another way after much persistence!

I put this in AutoOpen()

Application.CommandBars("cell").Enabled = False
CommandBars("Edit").Enabled = False

and put this in AutoClose()

Application.CommandBars("cell").Enabled = True
CommandBars("Edit").Enabled = True


I could of targeted a worksheet as well. Gee, it's good to have a win
every now and then.

Regards,

Wazza McG
No email replies please - reply to the newsgroup!