menu bar
in [General]
|
From: Atishoo on 4 Jul 2008 15:50 I have developed a spreadsheet that contains every control I need, including save and exit etc, as buttons embeded within the sheet. Is there a way to remove the menu column (File edit view insert etc) from the top of the page?? I suspect the answer is a unresounding NO! but hey worth trying!
From: Mike H on 4 Jul 2008 16:16 Hi, The answer is a resounding YES although it is a bit drastic Application.CommandBars("Worksheet Menu Bar").Enabled = False Put this in the workbook_open event and in the workbook before_close event with false change to TRUE Mike "Atishoo" wrote: > I have developed a spreadsheet that contains every control I need, including > save and exit etc, as buttons embeded within the sheet. > Is there a way to remove the menu column (File edit view insert etc) from > the top of the page?? > I suspect the answer is a unresounding NO! but hey worth trying!
From: Rick Rothstein (MVP - VB) on 4 Jul 2008 16:17 If you are allowed to use VBA code, execute this to hide the menu bar... Application.CommandBars("Worksheet Menu Bar").Enabled = False Use this to show it again... Application.CommandBars("Worksheet Menu Bar").Enabled = True Rick "Atishoo" <Atishoo(a)discussions.microsoft.com> wrote in message news:4C3B05DC-3726-4917-AE25-CCD22FDAA05A(a)microsoft.com... >I have developed a spreadsheet that contains every control I need, >including > save and exit etc, as buttons embeded within the sheet. > Is there a way to remove the menu column (File edit view insert etc) from > the top of the page?? > I suspect the answer is a unresounding NO! but hey worth trying!
From: Atishoo on 9 Jul 2008 15:07 Its great and works well , nearly locked myself out though! I created a macro to bring back the menu bar then realised I cant activiate the damned thing cos I aint got a menu bar!! Doh ! fortunately it has so many errors it soon threw up a debug error message!! On that theme is there anyway of stopping that too! "Rick Rothstein (MVP - VB)" wrote: > If you are allowed to use VBA code, execute this to hide the menu bar... > > Application.CommandBars("Worksheet Menu Bar").Enabled = False > > Use this to show it again... > > Application.CommandBars("Worksheet Menu Bar").Enabled = True > > Rick > > > "Atishoo" <Atishoo(a)discussions.microsoft.com> wrote in message > news:4C3B05DC-3726-4917-AE25-CCD22FDAA05A(a)microsoft.com... > >I have developed a spreadsheet that contains every control I need, > >including > > save and exit etc, as buttons embeded within the sheet. > > Is there a way to remove the menu column (File edit view insert etc) from > > the top of the page?? > > I suspect the answer is a unresounding NO! but hey worth trying! > >
From: Rick Rothstein (MVP - VB) on 9 Jul 2008 15:42 You could always press Alt+F11 to get into the VBA editor and enter Application.CommandBars("Worksheet Menu Bar").Enabled = True in the Immediate window in order to bring back the menu bar. As for your other question, "stopping" what, the debug error messages? You probably won't like the answer, but I think "fix your code" would be the usual response.<g> Seriously though, I don't think anyone will be able to help you with that unless you tell us what the errors are and show us your code (and identify where the program stops when issuing the error message). Rick "Atishoo" <Atishoo(a)discussions.microsoft.com> wrote in message news:B400C545-3422-4238-AA3B-1EC6F8A7F683(a)microsoft.com... > Its great and works well , nearly locked myself out though! I created a > macro > to bring back the menu bar then realised I cant activiate the damned thing > cos I aint got a menu bar!! Doh ! fortunately it has so many errors it > soon > threw up a debug error message!! > On that theme is there anyway of stopping that too! > > "Rick Rothstein (MVP - VB)" wrote: > >> If you are allowed to use VBA code, execute this to hide the menu bar... >> >> Application.CommandBars("Worksheet Menu Bar").Enabled = False >> >> Use this to show it again... >> >> Application.CommandBars("Worksheet Menu Bar").Enabled = True >> >> Rick >> >> >> "Atishoo" <Atishoo(a)discussions.microsoft.com> wrote in message >> news:4C3B05DC-3726-4917-AE25-CCD22FDAA05A(a)microsoft.com... >> >I have developed a spreadsheet that contains every control I need, >> >including >> > save and exit etc, as buttons embeded within the sheet. >> > Is there a way to remove the menu column (File edit view insert etc) >> > from >> > the top of the page?? >> > I suspect the answer is a unresounding NO! but hey worth trying! >> >>
|
Next
|
Last
Pages: 1 2 3 Prev: Were is the Tools menu in EXCEL 2007? Next: Sum formular using vlookup |