Sunday, April 11, 2021

hide ribbon in excel by vba

 Sub RemoveToolbars()


    On Error Resume Next


        With Application


           .DisplayFullScreen = True


           .CommandBars("Full Screen").Visible = False


           .CommandBars("MyToolbar").Enabled = True


           .CommandBars("MyToolbar").Visible = True


           .CommandBars("Worksheet Menu Bar").Enabled = False


        End With


    On Error GoTo 0


End Sub


No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...