Is it giving you the error that the cell or chart is protected and read only?
I only ask because, for example, I unlocked cells B2 through B20, then
password protected the sheet. I was able to enter data in B2, and drag it to
any cell in the aforementioned range. I could not, however, drag it to B21,
as the cell is still locked. Perhaps you should unlock the entire column(?or
row) that they will be dragging data to/from, go to Format--Cells,
protection tab, and ensure that the Locked box is not checked (or gray, which
indicates some are and some aren't Locked), then reprotect the sheet. I am
able, as I say, to drag and drop so long as I am dragging to an unlocked
cell. (I have Excel 2003).
--
John C


"Steve" wrote:

I use a password protected worksheet that I have created, and I need to be
able to drag the contents of cell A1 (for example) as far as Cell A21 on some
occasions so that they show the same content. , and once I have password
protected the sheet I can no longer do this. I know I could select A1 and
copy then select the cells I need and then paste, but I have created this for
others to use and they are all used to dragging a cell. It wouldn't occur to
them that they can copy and paste. Th problem happened when I put a password
on the sheet. Up to that point I could drag the cells. I've checked the
options and they still show that the option to drag is available, but I can't.

I'd be grateful for any help I can get.

Thank you

Steve