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