Strange Invisible Workbook

  • Thread starter Thread starter Mark Tewkesbury
  • Start date Start date
M

Mark Tewkesbury

Hi all,

I have a user that has managed to do something to an excel document
she had been working on that causes it to open up invisible. When she
double-clicks the file she gets the macro warning box. No matter what
you click on here (Enable or Disable) the document opens up blank.
You can see the toolbars and excel is still running so I know the
program has not crashed. I have tried the hide/unhide option,
nothing. When you select print preview option it says "Microsoft Excel
did not find anything to print." I check properties and the document
size is 52 KB so she did not overwrite it with a blank document.

I haven't encountered anything like this before so I am at a loss. I
am hoping someone here has seen this before and can provide some
insight.

Thanks,

Mark
 
Have you checked to see if the user saved the file with a blank sheet
active......could be data on another sheet.......or could be data on hidden
rows or columns........

hth
Vaya con Dios,
Chuck, CABGx3
 
Hi Mark,

If there's a macro-warning box, there must be some code in
the file. Try a search in the Visual Basic Editor for
all modules, classes, etc. for 'xlveryhidden'. In the
XL2000 help system you'll find:

"Visible Property
True if the object is visible. For a chart or worksheet,
this property can be set to xlVeryHidden. This hides the
object so that the only way for you to make it visible
again is by setting this property to True (the user cannot
make the object visible). Read/write Boolean or Long.

Remarks
The Visible property for a PivotTable item is True if the
item is currently visible in the table.

If you set the Visible property for a name to False, the
name won't appear in the Define Name dialog box."


Try this in a sample workbook if you like:
Sub HideThirdSheet()
Sheets(3).Visible = xlVeryHidden
End Sub

Best Regards,
Walt
 
Back
Top