Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide ribbon+command bars in 2003/2007 for specific file
I am developing a workbook for users that will be using excel 2003 and 2007.
I found code that will hide the ribbon and all command bars in both 2003 and 2007. Forgive the ignorance, but it seems to be happen to even new workbooks. I only want to hide everything for my specific file and for no others. How do I modify my code so that it only happens in my workbook and not in others that are open at the same time. I thought by putting the code in "ThisWorkbook" under the file it would only affect that specific file. Here is my current code: Private Sub Workbook_Open() Application.DisplayFormulaBar = False ActiveWindow.DisplayHeadings = False Application.DisplayFullScreen = True Application.DisplayStatusBar = False End Sub Private Sub Disable_Command_Bars_1() 'This will disable all Command bars Dim Cbar As CommandBar For Each Cbar In Application.CommandBars Cbar.Enabled = False Next End Sub (My goal is to hide all toolbars and ribbons, status bars, formula bars and right-clicking etc whether in 2003 or 07 so that it looks like a form it it's own window. I still want excel to work normally outside this file) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Excel Ribbon 2007 | Excel Programming | |||
how do I hide scroll bars on specific sheets within a workbook | Excel Discussion (Misc queries) | |||
Excel 2003 Command bars | Excel Programming | |||
Hide ribbon or menu bar in Excel 2007 | Excel Programming | |||
Hide all Excel tool/command bars except mine and reload on close | Excel Programming |