473,397 Members | 1,985 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

MS Excel 2000 - Possible macro corruption! HELP!!

I have been building a comprehensive spread sheet in MS Excel 2000, with numerous pages. Everything went well (using VB) and the task was complete. To enhance the users input I added a "Menu" page with macros (command buttons) to take the user to various pages. Great all going well! Until... All of a sudden a MS Message

"Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

Now I cannot enter the program - can anyone help me as I need a back door to delete the "Menu" page as I believe this may be the cause of the problem.
Mar 29 '08 #1
3 1439
Try opening the file with Macros disabled.


I have been building a comprehensive spread sheet in MS Excel 2000, with numerous pages. Everything went well (using VB) and the task was complete. To enhance the users input I added a "Menu" page with macros (command buttons) to take the user to various pages. Great all going well! Until... All of a sudden a MS Message

"Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

Now I cannot enter the program - can anyone help me as I need a back door to delete the "Menu" page as I believe this may be the cause of the problem.
Mar 29 '08 #2
I dont get the option! As soon as I try to open the file the Microsoft Message is dispalyed and then the whole of MS Excel closes! I have tried opening via Open Office with not much luck as it only allows 1 sheet to be imported and then there is no VB access that I can find.
If I could get at my code in Visual Basic I could recreate everything else. But I just dont how to get there! If I go to the VB editor in a fresh page I cannot access the code I want as I still need to open my problem file.

ANY IDEAS??
Mar 30 '08 #3
Mission accomplished! Microsoft Office 2007 has solved the problem
Mar 30 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Dean Bortell | last post by:
This code runs fine on win xp and office xp: string sheetPassword = "Senior1993"; string sheetToOpen = "NewRpt1c.xls"; Excel.Application excelApp = new Excel.Application();...
4
by: John Spiegel | last post by:
Hi All, Does anyone know of a site that might give some decent documentation on Excel 2000 objects, particularly their methods and parameters, in order? The little I've found so far seems to...
1
by: Giganews | last post by:
I have an Access 97 database in which I am running an Excel macro through automation. The macro in Excel is as follows: Worksheets("Sheet1").Protect Password:="****", DrawingObjects:=True,...
0
by: husky81 | last post by:
Greetings: I have Excel 2000 on my work pc. I've written some macros using the sendkeys command to control a mainframe application. A co-worker has Excel 2003. She seems to have a lot of...
1
by: Tom from Oakwood | last post by:
I'm writing VBA code in Excel 2000. I execute code which opens, one at a time, 10 Excel workbooks. It opens one, which does some manipulation of its own via a macro that executes upon opening,...
4
by: grego9 | last post by:
I am trying to write some VBA in Excel 2000 that scans down column L and inserts the Autosum command in each blank cell. Outside of VBA when I click the autosum command excel sums all the cells...
1
by: =?Utf-8?B?R2xlbm4gR29tZXo=?= | last post by:
Does Office Excel 2000 support XSLT transformation of data from XML cause am having problem when the attachment is opened in the client side if the Excels version is in Office 2000 and also its...
2
by: prakashsakthivel | last post by:
Hi Members, Is it possible to use Outlook 2003 from excel 2000. I am using Outlook 2003 and Excel 2000. While try to send mail automatically from excel 2000 (VBA), Application is giving...
2
by: grego9 | last post by:
Is it possible to create a macro that prompts the user to enter a password to access a specific sheet in Excel 2000? I can protect a sheet - but I cannot get a password prompt if the user tries to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.