Thread: Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
bhofsetz[_60_] bhofsetz[_60_] is offline
external usenet poster
  
Posts: 1
Default Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.

Oscar,

If you are ascessing the workbook and worksheet with VBA then why not
just set the visible property to true when using VBA to open the
workbook.

dim objExcel as Excel.Workbook
Set objExcel = GetObject(pathFile)

and set the application.visible to true by

objExcel.Application.Visible = True
Sheets(1).Visible = True


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=380706

Reply With QuoteReply With Quote