One sheet per window and no Ribbon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ingI'm writing an Excel application in VBA and I'd like to be able to do the
following

1) Hide and deactivate the ribbon so the user of my app won't accidently do
something he/she shouldn't

2) Lock a specific window to a specific worksheet -e. g. make the user
unable to change worksheets within a window. Presumably this would involve
making the worksheet tabs at the bottom of a window dissappear.

How might I accomplish the 2 things mentioned above?
 
With VBA

Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub


Hide the tabs and look in the VBA help for Application.Onkey to disable the shortcuts
Ctrl Page down and Up


See this page for xml examples
http://www.rondebruin.nl/ribbon.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


GeorgeJ said:
Well, I meant w/ VBA code. I'm not really sure what xml is.
Click to expand...
[/QUOTE]
 
Thank you Ron. Those subs work just as advertised - they were just what I
was looking for.
 
Back
Top