MENU BAR

[DonkeyOte]

I know this has been brought up time and time again but I thought I would ask if someone could tell me how I hide the menu bar (i.e. File, Edit, View etc)

I can't locate it's name...

Cheers and all that!
Luke

 

[Legacy 98055]

Luke

Application.CommandBars("WorkSheet Menu Bar").Enabled = False

I have had problems using the "Visible" property as opposed to the "Enabled" property.

Tom

 

[DonkeyOte]

Cheers Tom!

Shouldn't you be in bed now?

 

[verluc]

On 2002-09-19 02:10, TsTom wrote:
Luke

Application.CommandBars("WorkSheet Menu Bar").Enabled = False

I have had problems using the "Visible" property as opposed to the "Enabled" property.

Tom

Hi Tom,

I have done it as you say.
But now I can't see the icon of excel,so I can't call my code by opening workbook.
What to do to keep the icon of excel?
Thanks

 

[Legacy 98055]

Hi Verluc.
I don't understand what you mean by calling your code? I think the Excel icon cannot be moved. So if you disable the Menu Bar, the icon goes bye bye. If you are having trouble getting into the VBE, press ALT-F11 or right click on any worksheet tab and choose "View Code". Please explain further if I did not guess what your problem was.
Tom

 

[verluc]

On 2002-09-19 02:31, TsTom wrote:
Hi Verluc.
I don't understand what you mean by calling your code? I think the Excel icon cannot be moved. So if you disable the Menu Bar, the icon goes bye bye. If you are having trouble getting into the VBE, press ALT-F11 or right click on any worksheet tab and choose "View Code". Please explain further if I did not guess what your problem was.
Tom

Hi Tom,

Thanks for your time.
Yes I can see the code of the worksheet,following your way, but I can not see my code who are in "Workbook Open"
I had placed your code in Workbook Open and now I can not call this code.My problem: how can I see the code in Workbook Open?
With pressing the icon I could choose : This workbook,but now I have can't see the icon.

 

[Legacy 98055]

Ok, I see.
In the VBE, use your project explorer to work in the various modules. Click on "View", "Project Explorer". A docked window should appear listing the various objects in your project. Double-click "This Workbook" to view the code listed in that module. There should be a "Project Explorer" icon on the "Standard" toolbar as well. I do not know the shortcut key, but I assume that there is one.

Tom

 

[verluc]

On 2002-09-19 03:00, TsTom wrote:
Ok, I see.
In the VBE, use your project explorer to work in the various modules. Click on "View", "Project Explorer". A docked window should appear listing the various objects in your project. Double-click "This Workbook" to view the code listed in that module. There should be a "Project Explorer" icon on the "Standard" toolbar as well. I do not know the shortcut key, but I assume that there is one.

Tom

Million thanks Tom.It works.