edit features

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a template where there are certain cell that numeric data is entered
and sumed. The cell that contains the sum formula is protected. How do I
disable usersfrom cutting the contains of the unprotected cells were data is
entered. I need to do this because if they "cut and paste" is corrupts the
formula that sums the cells. I'm fairly good with excel but can't figure
this out and am not even sure that it is possible to do.
 
This is quite a pain. You have to programmatically disable the Cut command
on all the menus and toolbars it appears on and kill the shortcuts like
Ctrl-x. If you want an example email me.

--
Jim
|I have a template where there are certain cell that numeric data is entered
| and sumed. The cell that contains the sum formula is protected. How do I
| disable usersfrom cutting the contains of the unprotected cells were data
is
| entered. I need to do this because if they "cut and paste" is corrupts
the
| formula that sums the cells. I'm fairly good with excel but can't figure
| this out and am not even sure that it is possible to do.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
Summing rows using formulas with variables 1
Array Function to do a Sum of VLookUps that translate a letter gra 3
How to change a sum to an actual number I can paste into a new do. 4
Need help with macro to copy, paste, and clear cell values 8
Protect Cells 10
portected cells 5
Protect cells but allow for user input. 3

Back
Top