View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Turning off Cut and Copy?

Also one could wonder why the OP couldn't lock the formula cells and use a
couple of unlocked cells for input linked to the formula cells

--

Regards,

Peo Sjoblom

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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!