View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default How to make worksheet saved in VB6 visible?

The worksheets (all but one) are hidden ?
Or the Workbook window is hidden ?

If you are working on the file from VB6 when it is hidden and then save it,
it will remain hidden when opened in Excel.

Depends what you VB6 code is doing......

NickHK

"Lamont" wrote in message
...

A couple of years ago, when I did a GETOBJECT on an Excel Workbook from

VB6, Excel would display while my program was operating on it.

Now I can't make Excel display while under a VB6 app program.

But, more importantly, when my VB6 app saves the workbook and I then
bring it up directly under Excel, the worksheets are hidden and I have
to click "unhide" a couple of times to get the worksheets to be
visible.

I have tried MySheet.visible = true and that has no effect.

Thanks for kind advice. Lamont


--
Lamont
------------------------------------------------------------------------
Lamont's Profile: http://www.officehelp.in/member.php?userid=5022
View this thread: http://www.officehelp.in/showthread.php?t=1255993

Posted from - http://www.officehelp.in