Force to run maximized

R

Robyn

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
 
O

Office_Novice

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
 
J

Jeff Johnson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top