D
Dusan
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
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