Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One sheet per window and no Ribbon
Well, I meant w/ VBA code. I'm not really sure what xml is.
-- -regards |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
One sheet per window and no Ribbon
Thank you Ron. Those subs work just as advertised - they were just what I was looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel sheet in its own window | Setting up and Configuration of Excel | |||
How to Link on [Sheet(1) Window(1)] to [Sheet(2) Window(2)] ? | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Ribbon vs. Menus | Excel Discussion (Misc queries) | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) |