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!