If you have no menu bar hit Alt + F11 to open the Visual Basic Editor.

You can run the macro straight from the module you placed it in.

OR just copy Rick's one-liner to the Immediate Window and ENTER

Can't answer about all the errors...........can't see the code.


Gord Dibben MS Excel MVP

On Wed, 9 Jul 2008 12:07:01 -0700, Atishoo
wrote:

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!