Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow.Visible = True
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow.Visible = True
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow.Visible = True
Hi
We need to see your code. The problem could be anything - even something not related to the problem you have stated. regards Paul Paulo Alexandre ( PT PT ) wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow.Visible = True
Then again....it might be easily fixed...
Paul Paulo Alexandre ( PT ) wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow.Visible = True
You are welcome! Thanks for the feeadback!
Stefi €˛Paulo Alexandre ( PT )€¯ ezt Ć*rta: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWindow VBA problem | Excel Programming | |||
Shapes.visible = false/true | Excel Programming | |||
how to set pivotitem.visible property to true | Excel Programming | |||
How can I set PivotItem.Visible property to True? | Excel Programming | |||
error with setting "Items.Visible = True" | Excel Programming |