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! Think ahead if other people might be using this sheet, and not be expecting to have some data hidden.
This can cause its own set of problems if one or two digits are neatly hidden away. They will simply truncate anything that doesn't fit.īe careful now, because parts of your data may be hidden. Your cells will now not spill over either horizontally or vertically.
Check the height of an adjacent row for a good value. Now select the row(s) in question and manually set the row height, by right clicking the row number and selecting "Row Height". Select the cells in question and turn on text wrapping (Format>Cells>Alignment>Wrap Text). This is unnecessary, a pain in the but, and will mess up any ISBLANK type formulas, among other things. Some people have suggested putting a space in the next cell. Each of those solutions can mess up the layout of your sheet. Of course, you can make the column wider or turn on text wrapping, but you might not want to. How can you prevent a cell's contents from overflowing into the next cell? I am posting this solution for anybody still struggling with this. I saw two threads in this forum that asked this question, with no good answer. I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out! I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware.
It is the same Operating system and the same version of Excel. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. Nothing incredibly fancy but it works fine on my computer. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. I've written a macro that is relatively simple. I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise.