Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2012, 04:05 AM
Catalin.B Catalin.B is offline Excel stops responding after starting macro Windows Vista Excel stops responding after starting macro Office 2010 32bit
Expert
Excel stops responding after starting macro
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default


Well, i finally solved the problem, the code runs now fine on all machines...
But i guess it was an unusual bug of that specific version of excel , because even manually protecting or unprotecting that specific sheet caused excel to stop responding.

That sheet has a table, and ALL other sheet rows and columns outside the table was hidden (2003 type .xls workbook). When trying to unprotect the sheet (manually, or by VBA) , excel stops responding and excel.exe process goes to 100% CPU.
I just set all sheet rows and columns to unhidden, and the problem dissapeared.
I couldn't find an answer why excel crashes on a sheet with all rows and columns outside the table hidden.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook stops responding JAZIT Outlook 0 04-11-2012 12:11 AM
Excel stops responding after starting macro When opening a file, Word stops responding. bTaryag Word 9 10-25-2011 09:39 AM
Help finding starting point on project (Excel/Access?) ndk415 Office 1 06-19-2011 03:28 AM
Excel stops responding after starting macro Clip Art not responding RogerMantle Office 1 06-13-2009 01:14 AM
Microsoft Word Not Responding- Help Gom Word 0 03-12-2009 07:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft