Force to run maximized
 

I need to accomplish the following in a workbook:
-Force to run maximized and not allow form movement within the screen
-Disable Save and Save as
-Disable shortcut keys

Return to normal settings after workbook close

Force to run maximized
 

I can help with some of that, To maximize the form use this

Option Explicit

Private Sub UserForm_Initialize()
Me.Height = Application.UsableHeight
Me.Width = Application.UsableWidth

End Sub


"Robyn" wrote:

I need to accomplish the following in a workbook:
-Force to run maximized and not allow form movement within the screen
-Disable Save and Save as
-Disable shortcut keys

Return to normal settings after workbook close

Force to run maximized
 

"Robyn" wrote in message
...

I need to accomplish the following in a workbook:
-Force to run maximized and not allow form movement within the screen

What do you mean by form? UserForm or just the Workbook itself? What about
Excel itself?

Force to run maximized
 

The workbook and if possible Excel as well, (while the workbook is active only)

"Jeff Johnson" wrote:

"Robyn" wrote in message
...

I need to accomplish the following in a workbook:
-Force to run maximized and not allow form movement within the screen

What do you mean by form? UserForm or just the Workbook itself? What about
Excel itself?