Insert cell

[Stanley Braverman]

I have a very strange problem. When I go to a cell and right click and
select insert cell I get the dialog box that selects second option "shift
cells down" and it works correctly. But not again for 10 minutes? What I
get instead is dialog box with first option selected and when I select
second option "shift cells down" I get pop up box with error message "To
prevent possible loss of data etc,etc, etc." However after several very
long minutes it will work correctly once and then have to wait again??

Using Excel 2002

 

[Simon Lloyd]

It sounds like you have code running, it may be contained in te
worksheet calculate, change or selectionchange event, to find it righ
click on your worksheet tab and choose View Code and see whats ther
that may be interfering with your paste, if there is nothing there i
may be in the ThisWorkbook module, to see that press Alt+F11 then doubl
click Thisworkbook on the left hand side

I have a very strange problem. When I go to a cell and right click an
select insert cell I get the dialog box that selects second optio
"shif
cells down" and it works correctly. But not again for 10 minutes? Wha

get instead is dialog box with first option selected and when I selec
second option "shift cells down" I get pop up box with error messag
"T
prevent possible loss of data etc,etc, etc." However after several ver
long minutes it will work correctly once and then have to wait again?

Using Excel 200

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com