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

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

"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?

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?