copy & paste not working

[mike knopfler]

i can't understand it but i am unable
to copy and paste a block.

i get as far as tagging the block to copy
but when i go to a new cell to paste, the paste
function is dimmed out ...


it wasn't always like this

can anyone tell me what is going on ????

 

[Chip Pearson]

Mike,

Is the worksheet protected?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Norman Harker]

Hi Mike!

Sounds like you're working on a protected sheet.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 6th August 2003: Bolivia
(Independence Day), Bulgaria (The Transfiguration), Jamaica
(Independence Day), United Arab Emirates (Accession of H.H. Sheikh
Zayed). Observances: Hiroshima Day (08:15 Local Time 6th August 1945),
Hiroshima Peace Ceremony (Shinto), The Transfiguration (Christianity).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[mike]

hi

no it is not protected

i can copy and paste a single cell ONLY if i copy
it from the STATUS/EDIT line

but if i want to copy cells a1 to a3 and paste
it to cells b1 to b3
when i put the cursor on b1 , the paste menu option
becomes DIMMED OUT
it is NOT so when it is STILL on cell a1

I AM TOTALLY LOST

 

[Dave Peterson]

Maybe you have a worksheet_selectionchange event macro firing. If you open the
workbook with macros disabled, can you paste?

If yes, right click on the worksheet tab and select view code. Is there
anything there?

There might be something under ThisWorkbook, too
(Workbook_SheetSelectionChange).

Depending on what happens, these kinds of event macros can kill the clipboard.

 

[mike knopfler]

you got it !!!!

i opened a new workbook and it worked just fine.

now , i will have to find the macro that
is killing my own form. i don't think it is going
to be fun.

thanks for the help

 

[Dave Peterson]

If it happens on only one sheet, look under that sheet first. right click on
the worksheet tab and select view code.

If it's not there, look under ThisWorkbook. It could be lurking in that module,
too.