Disabling Close, minimize, and restore

  • Thread starter Thread starter kristing
  • Start date Start date
K

kristing

Is there a way to disable close, minimize and restore in an exce
workbook by using VBA
 
Hi kristing,

Private Sub Workbook_Open()
Application.ThisWorkbook.Protect Windows:=True
End Sub

Regards,
MP
 
You must log in or register to reply here.

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

Similar Threads

Best PST Recovery Software 3
Is there a fancy way to open a workbook in a minimized window stat 2
Any vba code to disable only close button in Excel workbook, please? 1
Outlook Minimizing composed outlook emails without disappearing 1
Disable Minimize/Maximize button for Excel 2007 Application 3
Excel VBA in Citrix. 0
Detect Excel minimize and restore? 5
Minimize the ribbon in Excel 2007 using code 1

Back
Top