I've tried similar settings but nothing worked.
Another 'weird' issue : I can't code

Sheets(1).Visible = True

When I press a dot after the (1) , the VB intellisense doesn't show me any
methods or properties. In case I force to set .Visible =True an error is
fired in runtime

Remember that I noted that I use VB (within MS Visual Basic), not VBA in
Excel
---
Oscar



"bhofsetz" schreef
in bericht ...

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