Force to run maximized

  • Thread starter Thread starter Robyn
  • Start date Start date
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
 
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
 
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)
 

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

Back
Top