Pasting values

[grkchakri]

Hi All

i have certain number from a diffrent application which should be pasted into one of the cell for exampe
In "C5"

C5 should allow to only paste values. But i dont want user to key/type anything in c5 other
pasting values.

Can we have vba code regarding the above.. I am expecting that it should be something around "ALLOW EDIT ", "Pastespecial"

Many Thanx

[natefarm]

I'm not aware of a way to directly do what you are asking, but this might work for you:

1. Right-click the cell, select Format Cells, and make sure the Protection property is Locked.
2. Protect the worksheet (leave password-protection off for now).
3. Select and copy the data you want to paste.
4. Start the macro recorder, enter a shortcut key value (like 'p' for Paste) and do the following:
5. Unprotect the worksheet.
6. Select the cell to be updated.
7. Paste the data.
8. Protect the worksheet.
9. Turn off the macro recorder.

Check your macro code and revise as needed. If you want the sheet password-protected, add Password:="mypassword" to the .Unprotect and .Protect methods.

To test, clear the cell value, select some data, and on the worksheet, click Ctrl+p.

[grkchakri]

While i try the above

If i was not clear in my question here it goes

1) User should be able to only paste values ( values will be a copied from a different software where ctrl+c works)

2) No direct input in the cells( i mean user should not type only use those cells to paste values)

3) Each time i get a number / result i copy them and paste them in each cells

Thank you

[grkchakri]

Thnx nate i was able to record a macro and amend that accordingly