Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste disabled
I have a workbook to which users will be copying and pasting data from
another workbook. In the workbook to which the data is being pasted is a range of unlocked cells (a column of 10 continguous cells) and the worksheet is protected to allow users to edit only these unlocked cells. When trying to paste from another workbook a column of 10 continguous cells, the paste function is disabled, so I can't paste into my protected worksheet. Does anyone know why this is happening??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste disabled
Emma,
You don't say which version of Excel you're using. I tried this on Excel 2002 and it worked fine with no problem. I would double-check the cell locking on your 10 cells. Note that if any of the 10 cells are locked, the paste will fail for all 10. Also, if they're trying to insert, it won't work. Also, when you protect the sheet, make sure that Select locked cells and Select unlocked cells is checked in the list, but nothing else. Hope this helps! James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste Special and Linking | Excel Discussion (Misc queries) | |||
need custom cut and paste functions | New Users to Excel | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel |