Trying to Hide the Min Max Close at top right

Polino

New Member
Joined
Apr 1, 2022
Messages
12
Office Version
  1. 2019
Platform
  1. Windows
These are the 2 macro that I'm Using, it's all perfect other than the Minimize - Maximize and close

Sub HideAll()
'
' Excel VBA Tutorial - Microsoft Excel Tutorials, Help, Forum, and more - TeachExcel.com

' Hide the Horizontal Scroll Bar
ActiveWindow.DisplayHorizontalScrollBar = False

' Hide the Vertical Scroll Bar
ActiveWindow.DisplayVerticalScrollBar = False

' Hide the Row/Column Headings
ActiveWindow.DisplayHeadings = False

' Hide the Worksheet Tabs
ActiveWindow.DisplayWorkbookTabs = False

' Hide the Status Bar (bottom of the window)
Application.DisplayStatusBar = False

' Hide the Formula Bar
Application.DisplayFormulaBar = False

' Hide the Ribbon Menu and Quick Access Toolbar
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"

' Display Full Screen
'Application.DisplayFullScreen = True
' Size all screen

Application.WindowState = xlNormal
Application.Top = 80
Application.Left = 400
Application.Width = 375
Application.Height = 500

Application.ThisWorkbook.Protect Windows:=True

End Sub



Sub ShowAll()
' ShowAll Macro
' Excel VBA Tutorial - Microsoft Excel Tutorials, Help, Forum, and more - TeachExcel.com
'
' Just reverse the options in the previous macro -> False becomes True
' and True becomes False.

' Exit Full Screen
' - If this was used to show full screen after other display settings
' were changed, then put it before those settings are changed back.
' Full-screen mode and normal mode maintain separate settings for
' these.
'Application.DisplayFullScreen = False

' Show the Horizontal Scroll Bar
ActiveWindow.DisplayHorizontalScrollBar = True

' Show the Vertical Scroll Bar
ActiveWindow.DisplayVerticalScrollBar = True

' Show the Row/Column Headings
ActiveWindow.DisplayHeadings = True

' Show the Worksheet Tabs
ActiveWindow.DisplayWorkbookTabs = True

' Show the Status Bar (bottom of the window)
Application.DisplayStatusBar = True

' Show the Formula Bar
Application.DisplayFormulaBar = True

' Show the Ribbon Menu and Quick Access Toolbar
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"

Application.WindowState = xlNormal
Application.Top = 20
Application.Left = 200
Application.Width = 975
Application.Height = 700
End Sub
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top