See Dave's reply about VBA code protection.

Code interruption will not unprotect or show the code module when an error
arises.


Gord

On Wed, 9 Jul 2008 17:35:04 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

Can you take a look at Atishoo's last response to me (where he clarifies
what he meant to ask)? Excel security is not one of my strengths and I
thought you might be able to provide him with direction. Thanks.

Rick


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