Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
EXCEL 2002. This is a follow-up to another post of mine that hasn't
appeared yet: "Whose error: Mine or Excel's?". That was about the same problem described here, but some of the information given there is probably irrelevant. I'm not really sure what is relevant. The workbook in question has 7 visible worksheets and 3 hidden worksheets. There are about 70 embedded controls spread over 3 of the worksheets that also contain one embedded chart each. The size of the .xls file is about 1 MB. So it's not a huge project. OK, here's the problem. I add a new CommandButton control to one of the worksheets that already has a chart and 21 other controls. I don't do anything else - no code added behind the button. I save the workbook, close it, and open it again. Now, I get the dreaded box that says "Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience". And if I follow the option to "Recover my work and restart Excel", it opens the file with ALL the VBA code stripped out. This happens even if I disable macros on startup. I can add a CommandButton and even a couple of extra OptionButtons to either of the other two worksheets containing charts and controls, and the project survives. So there's something about the particular sheet I'm trying to change. But I'm clueless what else to try, or what information to provide here, unless someone knows enough about this kind of problem to ask the right question.....??? Thanks, Ken Dahlberg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel instability - screen scrolls to end of sheet on right hand side | Excel Discussion (Misc queries) | |||
anyone experiencing graphics instability in Excel 2007 | Excel Discussion (Misc queries) | |||
Large Charts Cause Instability | Charts and Charting in Excel | |||
Excel 2007 instability | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) |