Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I have a question regarding the window size. I'd like to define the application window size which I've done by: Application.WindowState = xlNormal Application.Left = 0 Application.Top = 0 Application.Width = 770 Application.Height = 484 ActiveWindow.WindowState = xlMaximized ActiveWorkbook.Protect , True , True Now I want to lock application window size and prevent users to change it. Only minimizing and restoring to defined size would be possible. It's possible to lock the workbook window size but not the application window. The command: Application.Protect , True, True simply does not exist. There must be some other way to lock application window size. Any help aapreciated. Thank you Dusan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
How to Determine if Application Window Still Active | Excel Discussion (Misc queries) | |||
How do I open a new window for each excel application? | New Users to Excel | |||
How to set Excel to open a new window for each application | Excel Discussion (Misc queries) | |||
How do I set up Excel to open a new instance/application window w. | Excel Discussion (Misc queries) |