One sheet per window and no Ribbon
 

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?

--
-regards

One sheet per window and no Ribbon
 

Hi GeorgeJ

With VBA code or with xml(no VBA code)

--

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


"GeorgeJ" wrote in message ...
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?

--
-regards

One sheet per window and no Ribbon
 

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

One sheet per window and no Ribbon
 

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" wrote in message ...
Well, I meant w/ VBA code. I'm not really sure what xml is.
--
-regards

One sheet per window and no Ribbon
 

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