LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make a drop down box visible within a worksheet? skittles_golf Excel Worksheet Functions 42 April 21st 23 02:59 PM
I need to make MS word visible..please help Steven Excel Programming 4 October 19th 05 05:44 PM
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. Oscar Excel Programming 6 June 21st 05 10:39 PM
better search: "make worksheet visible" christo Excel Discussion (Misc queries) 1 December 1st 04 12:20 AM
How select all pictures in a worksheet and make visible? Gunnar Johansson Excel Programming 5 November 2nd 04 09:50 PM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"