Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form, Dual Monitors
I am using Excel 2007 on Windows XP with dual monitors. I have a work
book that is to be shared that has a form that I built. For some reason when the workbook is open on one screen the form will open on the other monitor. Any ideas why and how to control/ prevent this? Also, I would like to prevent users from using Alt+F8 to run macros and from using Alt+F11 to see the VBE. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form, Dual Monitors
On 25 Ago, 01:02, Slim Slender wrote:
I am using Excel 2007 on Windows XP with dual monitors. I have a work book that is to be shared that has a form that I built. For some reason when the workbook is open on one screen the form will open on the other monitor. Any ideas why and how to control/ prevent this? Try this: Private Sub UserForm_Initialize() With Me .StartUpPosition = 3 .Left = (Application.ActiveWindow.Width - .Width) / 2 .Top = (Application.ActiveWindow.Height) / 2 End With End Sub Tnk for feedback. Bye! Scossa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing with dual monitors | Excel Discussion (Misc queries) | |||
Dual monitors | Excel Discussion (Misc queries) | |||
how do I use excel on dual monitors | Excel Discussion (Misc queries) | |||
Coding For Dual Monitors | Excel Discussion (Misc queries) | |||
Dual monitors | Excel Discussion (Misc queries) |