Guest User

Untitled

a guest
Jul 11th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. ' ----------------------------------------------------------------
  2. ' Procedure Name: ToggleRibbon
  3. ' Purpose: Toggle the visibilty of the Excel ribbon and menu bars
  4. ' Procedure Kind: Sub
  5. ' Procedure Access: Public
  6. ' Author: sb172a
  7. ' Date: 7/11/2018
  8. ' ----------------------------------------------------------------
  9. Sub ToggleRibbon()
  10. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", " & CStr(Not Application.CommandBars("Ribbon").Visible) & ")"
  11. End Sub
Add Comment
Please, Sign In to add comment