Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert cell
It sounds like you have code running, it may be contained in teh worksheet calculate, change or selectionchange event, to find it right click on your worksheet tab and choose View Code and see whats there that may be interfering with your paste, if there is nothing there it may be in the ThisWorkbook module, to see that press Alt+F11 then double click Thisworkbook on the left hand side. Stanley Braverman;246461 Wrote: 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 Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68794 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Programming | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |