LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default VBA project instability

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel instability - screen scrolls to end of sheet on right hand side Scott Excel Discussion (Misc queries) 2 May 20th 12 08:47 PM
anyone experiencing graphics instability in Excel 2007 Peter TC Excel Discussion (Misc queries) 0 March 4th 10 10:50 AM
Large Charts Cause Instability pmjboyle Charts and Charting in Excel 3 August 31st 07 02:21 AM
Excel 2007 instability MK Excel Discussion (Misc queries) 1 February 9th 07 09:36 PM
How to convert MS Project to MS Excel. I don't have MS Project. Jane Excel Discussion (Misc queries) 1 February 20th 06 10:01 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"