Run-time error 1004 in Excel

Microsoft Windows xp professional (upgr...
January 7, 2010 at 03:12:42
Specs: Windows XP
Hi all,

A user is unable to access the code on an excel document. It is asking for a password but the document isn't protected. Also when you try and close the file you get Run-time error '1004': Unabled to set the visible property of the worksheet class. The options Continue and Debug are greyed out and you only have End or Help.

The user is the only one with access to this file and claim they have NOT protected the worksheet.

User has Excel 2007, I have also tested on Excel 2000SP3.

Any ideas?


See More: Run-time error 1004 in Excel

Report •

January 9, 2010 at 15:56:09
First hit on Google:

Did you search before posting?


Report •

January 9, 2010 at 17:22:20
Yes i read that KB and many posts beforehand. I can't find any that are showing the same symptoms. Most of the posts were resolved by unprotecting it, but that is one of the problems.. it wasn't protected but now it is.

The KB artical you posted isn't for the same problem. Error number is the same but message is different.

"Run-time error '1004': Unabled to set the visible property of the worksheet class."

Report •

January 9, 2010 at 21:32:24
Are you sure that's the error? I found "Unable to set the visible property of the worksheet class" but not "Unabled to set..."


Report •

Related Solutions

January 10, 2010 at 03:35:40
Typo.. replace unabled for unable.

Google will pick up the correct error even when you put in the typo anyway.

Report •

August 27, 2010 at 05:40:18
see thw file protection 7 install ur excel with extra feature. like vb & patch enable.

Report •

October 20, 2010 at 22:05:57
Hi Michael,

This error is typically generated in either Visual basic or Excel. In your case which is in excel, have you also received an accompanying text like “Copy method of worksheet class failed,” or a similar message? In that case, you need to click
start>explorer>then open C:\Program Files\MS Office\XLSTART directory

if you see GWXL97.XLA, delete it then close the explorer. Your excel should work fine by then. There are also other strategies to prevent this error from coming up, depending on what caused it. If you were trying to copy the worksheet more than once without saving your work and closing the workbook in between, then this error came up, you'll need to follow different approach...And the approach also depends on your excel version. For more detailed steps, just follow this guide on fixing runtime error 1004

Report •

Ask Question