Ah ha,
That is it. I had loaded a worksheet that had a message saying that
copy and paste was disabled.
I dont know why they did not have a macro triggered by the close
action to remove those restrictions!! (the worksheet was developed by
the indian income tax dept to help e-filing so I guess that
figures) :)

regards,
chandrasekhar

On Nov 1, 10:49 pm, Gord Dibben <gorddibbATshawDOTca wrote:
That setting would not have changed "on its own".

It was user-assisted or some workbook you loaded had code to disable it.

Gord Dibben MS Excel MVP



On Thu, 01 Nov 2007 09:34:38 -0700, wrote:
Great, thanks.It worked.
Any idea why it could change on its own?

regards
chandrasekhar

Check he
Tools Options Edit tab
"Allow cell drag and drop" should be ticked.
Does this solve the problem?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -