One sheet per window and no Ribbon

[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?

 

[Ron de Bruin]

Hi GeorgeJ

With VBA code or with xml(no VBA code)

 

[Guest]

Well, I meant w/ VBA code. I'm not really sure what xml is.

 

[Ron de Bruin]

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

Well, I meant w/ VBA code. I'm not really sure what xml is.

[/QUOTE]

 

[Guest]

Thank you Ron. Those subs work just as advertised - they were just what I
was looking for.