Weird Excel Behavior - Have you seen this?

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9
I have a user that is not able to get an excel file to open. This is what it does. It will open, but nothing will come up on his screen. Almost like it is locked up, but if he does print preview, he can see it. Anyone else that opens this file is able to open it no problem. Have you ever seen this and any ideas why this is happening? He is on excel 97 Windows 2000.

Thanks, Shawnna
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
OK, just to be sure:
Open the file, Go to VB Editor (Alt+F11), and put this in the Immediate window:
Code:
? ThisWorkbook.IsAddin
Hit Enter. What does it say? False or True?
Martin
 
Upvote 0

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
Another idea:
try to run this code
Code:
Sub Unhide()
For Each ws In Workbooks("Rimage 626411.xls").Sheets
    ws.Visible = True
Next ws
End Sub
Maybe it's an old file with hidden module sheets.
Martin
 
Upvote 0

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9
No matter where I put it, I keep getting this error. "438 - Object doesn't support this method."

I put it in the immediate window. Created a macro and then put it in that area, and even created a form and then added a button to it and had the code on the button. Still will not take the code.
 
Upvote 0

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9
No matter where I put it, I keep getting this error. "438 - Object doesn't support this method."

I put it in the immediate window. Created a macro and then put it in that area, and even created a form and then added a button to it and had the code on the button. Still will not take the code.
 
Upvote 0

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
It's strange that you can see the workbook in preview.
Where do you get the 438 error? In both cases? The .IsAddin is also not working?
Do you have a name of some sheet inside the book? We can try to retrieve the values either via formulas or via XLM code.
Martin
 
Upvote 0

Forum statistics

Threads
1,186,361
Messages
5,957,402
Members
438,304
Latest member
duck90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top