View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paulo Alexandre ( PT )[_2_] Paulo Alexandre ( PT )[_2_] is offline
external usenet poster
 
Posts: 2
Default ActiveWindow.Visible = True

Thks Stefi
It worked just fine.
Thks a lot

"Stefi" wrote:

Try
Windows("your workbook name.xls").Visible = True

Regards,
Stefi

€˛Paulo Alexandre ( PT )€¯ ezt Ć*rta:

I've executed in a VBA Project I'm developing an instruction to Hide the
Workbook, the following instruction ( ActiveWindow.Visible = False ), and in
the end I changed it's value to True, but unfortunatlly I realize that I just
can't change is value back to true to solve the visibility problem, it gives
me an error ( Run-time error "91" - Object variable or With block variable no
set).
I really need Help to programmaticaly make Visible my Workbook, because I
can use it ( Macros ), but I can't see It, I enter in VBA but I don't see my
Worksheet, and I've also a lot of info in the worksheets.
Thks