#1
|
|||
|
|||
Excel stops responding after starting macro
Hi,
I have a very weird situation, when using a workbook . The file is located on a shared drive, on an xp home edition. When i open this file from another computer from the network (with vista), and run macros from this file, works fine. Works fine too on xp home with office 2003 basic, and on vista with office 2010 pro (mine), and on an xp pro with office 2003 pro. The problem is that excel stops responding when running a macro on this workbook from 2 computers, with xp pro and office 2003 pro. The line at which excel stops responding is the .Unprotect method for unprotecting the sheet before making changes in file. The problem is this program worked even on these computers, only a few days ago stopped responding. I suspect an update or local security policies (users on these computers are using limited accounts). I know that this method fails only on protected shared workbooks, but this is not shared, only one user at a time can make changes . Any advice is highly appreciated... Catalin L.E: Excel stops responding and i have to kill the process even under admin account on the 2 computers... Last edited by Catalin.B; 05-10-2012 at 08:35 AM. |
#2
|
||||
|
||||
Hi Catalin,
From the sounds of it, it would definitely be worth checking what's been installed on those two PCs in the last few days. It would also be worth disabling all add-ins (including COM add-ins) to see if one of them might be causing the interference. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook stops responding | JAZIT | Outlook | 0 | 04-11-2012 12:11 AM |
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 |
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 |