Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Positioning the Calendar on working screen
How to find the working screen top, left, width and height.
when I pop up the calendar it goes some times goes out of screen. This is forcing the user to scroll the window. I tried activewindow but it is not the working area. Thanks for the help. MVM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Positioning the Calendar on working screen
Hi MVM,
Look at the VisibleRange Property in VBA help. '============= Public Sub Tester() Dim rng As Range Set rng = ActiveWindow.VisibleRange With rng Debug.Print .Top, .Left, .Width, .Height End With End Sub '<<============= --- Regards, Norman "MVM" wrote in message ... How to find the working screen top, left, width and height. when I pop up the calendar it goes some times goes out of screen. This is forcing the user to scroll the window. I tried activewindow but it is not the working area. Thanks for the help. MVM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FLICKERING SCREEN WHEN WORKING | Excel Discussion (Misc queries) | |||
Hyperlink Destination Positioning On Screen | Excel Worksheet Functions | |||
Screen Positioning of a Dialogue Box ! | Excel Programming | |||
Positioning a cell at the top left of the screen | Excel Programming | |||
Screen Updates not working ? | Excel Programming |