LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
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
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM
Using other workbooks.. DavidMunday Excel Worksheet Functions 2 July 1st 05 07:35 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM
Printing a Pivot Table from code - Excel 2003 Newbie Excel Discussion (Misc queries) 4 January 5th 05 04:10 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM


All times are GMT +1. The time now is 02:46 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"