Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Ribbon in '07
Hi,
I have a piece of code that disables the ribbon under Vista in Office '07: Private Sub Workbook_Open() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" ' disables user ribbon functionality <do other stuff here end sub() This works as intended but it also turns off the ribbon in any other spreadsheets that are open at the same time. Is it possible to turn off the ribbon only in my spreadsheet? TIA Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Ribbon in '07
Make a Workbook_Activate event that calls Workbook_Open and a
Workbook_Deactivate event that reverses your Workbook_Open event. This should work. -- I am running on Office 2003, unless otherwise stated. "Risky Dave" wrote: Hi, I have a piece of code that disables the ribbon under Vista in Office '07: Private Sub Workbook_Open() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" ' disables user ribbon functionality <do other stuff here end sub() This works as intended but it also turns off the ribbon in any other spreadsheets that are open at the same time. Is it possible to turn off the ribbon only in my spreadsheet? TIA Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Ribbon in '07
Perfect! My thanks
"Orion Cochrane" wrote: Make a Workbook_Activate event that calls Workbook_Open and a Workbook_Deactivate event that reverses your Workbook_Open event. This should work. -- I am running on Office 2003, unless otherwise stated. "Risky Dave" wrote: Hi, I have a piece of code that disables the ribbon under Vista in Office '07: Private Sub Workbook_Open() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" ' disables user ribbon functionality <do other stuff here end sub() This works as intended but it also turns off the ribbon in any other spreadsheets that are open at the same time. Is it possible to turn off the ribbon only in my spreadsheet? TIA Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Ribbon in '07
No problem. I know this because when I manipulate the Status Bar, I want the
messages contained to only apply to the specific workbook. Glad to help! -- I am running on Office 2003, unless otherwise stated. "Risky Dave" wrote: Perfect! My thanks "Orion Cochrane" wrote: Make a Workbook_Activate event that calls Workbook_Open and a Workbook_Deactivate event that reverses your Workbook_Open event. This should work. -- I am running on Office 2003, unless otherwise stated. "Risky Dave" wrote: Hi, I have a piece of code that disables the ribbon under Vista in Office '07: Private Sub Workbook_Open() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" ' disables user ribbon functionality <do other stuff here end sub() This works as intended but it also turns off the ribbon in any other spreadsheets that are open at the same time. Is it possible to turn off the ribbon only in my spreadsheet? TIA Dave |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Ribbon in '07
Hi Risky
You can also do it without code (with RibbonX) See http://www.rondebruin.nl/ribbon.htm Try one of the dictator examples in section 2 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Risky Dave" wrote in message ... Hi, I have a piece of code that disables the ribbon under Vista in Office '07: Private Sub Workbook_Open() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" ' disables user ribbon functionality <do other stuff here end sub() This works as intended but it also turns off the ribbon in any other spreadsheets that are open at the same time. Is it possible to turn off the ribbon only in my spreadsheet? TIA Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ribbon | Excel Discussion (Misc queries) | |||
The Ribbon | Excel Discussion (Misc queries) | |||
Ribbon | New Users to Excel | |||
ribbon | Excel Discussion (Misc queries) | |||
Can we modify any of the ribbon tabs or create new ribbon tabs? | New Users to Excel |