View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Turning off Cut and Copy?

Of course, this does nothing to disable <Ctrl X and <Ctrl V, which is how
I usually cut and paste, or to disable the related toolbar buttons!

--

Vasant

"Wazza McG" <Back Off Hairy wrote in message
u...
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!