I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. Mine has Office 2010, so I think there might be an issue with the file itself.Īlso, not just copy and paste. I am trying this on his workstation and mine. When I click save, it will change the display value to 80. Right click A3, Copy, right click B3, paste When copying a cell with a formula in it of "=D6+C6" and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of "=D7+C7". I have a co-worker's file that he is having trouble with. I tried searching for anything simmilar to this and can't find anything.Īny help would be much appreciated. If I hit the save button in the VBE (since I can't click anything in the excel window), then it seems to snap out of it and go back to normal. the VBE) is on top of it, clicking into the excel window just gives the little system 'ding' sound and nothing happens. I also can't really bring focus to the excel window if something else (ie. But if I type anything else (numbers, letters, or symbols) then it types 2 instances of the key every time, yet when I hit enter, nothing changes in the cell. If I use the delete key to delete the contents of a cell, then it gets deleted. If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems.
Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. If I go into the VBE, I can manually run procedures and they all work fine. I've made sure that screenupdating is turned back on at the end of every procedure. I can't think of anything in my macro that would have these kinds of effects. I don't understand what's going on at all. So if I press "s' it will input "ss" into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. I have a fairly lengthy macro that works perfectly most of the time. I've been having a strange problem lately.
Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! It's like the buttons are being disabled when I close or open the file. When I reopen the file none of the buttons work.
The odd thing is if I create a new button it works fine until I save and close the file. I still see the button name "cmdButtonGetInfo" and "=EMBED("Forms.CommandButton.1","") in the name box and formula bar. I can't seem to locate the command button properties any longer. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. Now when I open the workbook, the buttons don't work! When I click them nothing happens. Then I saved and closed the workbook and went to lunch.
#Excel 2103 right click copy not working code
I added the _Click code to run the macros when the user clicked the buttons.Īll of the buttons were working fine. I got into the button properties and set the background colors. So I removed the form control buttons and created new ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. I'm having a problem in a workbook with several ActiveX command buttons.
0 kommentar(er)
