Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
Anthony,
Definitely look at the xlb file as Gord suggested. Henry has already ruled out a runaway Auto_Open or Workbook_Open macro. When things are weird , there are a few other things we routinely do. Can't hurt: Look at "Excel acts generally goofy" at http://www.smokeylake.com/excel/vfaq.htm. Try those things. The workbook may be damaged. Depending on your version lf Excel, you may be able to repair it. File - Open, click the dropdown in the "Open" button and do "Open and repair." If you don't have that (your version of Excel is too old), send it to someone with a later version who might be able to do this. Are the applicable service packs installed for your version of Excel? You can download them from microsoft.com. I'm hiding under the table as I say: I hope you have a backup of the file. Good luck. -- Earl Kiosterud www.smokeylake.com "Anthony" wrote in message ... Earl, maybe not, basically I created a workbook with a personal toolbar and many macros to carry out various tasks. I can Open the worksheet , but as soon as I do the mouse cursor changes to the egg times and after a few seconds I get 'Not Responding'. I can't click on anything within the sheet apart from the 'minimise' 'maximise' and 'close' any suggestions "Earl Kiosterud" wrote: Anthony, If your code is in a loop, press Ctrl-Break to stop it. Is that what you mean by "frozen?" -- Earl Kiosterud www.smokeylake.com "Anthony" wrote in message ... Hi Any know how to get into VB editor when excel programme is frozen. My worksheet is frozen and I can't get it back - but I want my VB code from it. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Printing a Pivot Table from code - Excel 2003 | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |