Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run my
excel sheet ??

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run my
excel sheet ??

Ok,now it's working fine,but how can i make it appear again
Thanx


"Bob Phillips" wrote:

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run my
excel sheet ??

Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB

Application.DisplayFormulaBar = mFormulaBar


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Ok,now it's working fine,but how can i make it appear again
Thanx


"Bob Phillips" wrote:

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run
my
excel sheet ??

Hi "Bob Phillips",
Really i appreciate your help,but i have two problems:
1-The macro "autoexec" that hides the menus when i open my excel sheet
spmetimes works and sometimes no !!!
2-When i open any other excel sheet the menus are always hidden, i need to
hide these menus only from a certain sheet called "my team KPIs"

Regards

"Bob Phillips" wrote:

Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB

Application.DisplayFormulaBar = mFormulaBar


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Ok,now it's working fine,but how can i make it appear again
Thanx


"Bob Phillips" wrote:

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run
my
excel sheet ??

I have no idea what autoexec is or does so you will need to give more detail
here.

If you want those menus hidden only for that s/s, you need to put the hide
in the workbook activate procedure, and show them in the workbook deactivate
event procedure for the workbook in question.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Hi "Bob Phillips",
Really i appreciate your help,but i have two problems:
1-The macro "autoexec" that hides the menus when i open my excel sheet
spmetimes works and sometimes no !!!
2-When i open any other excel sheet the menus are always hidden, i need to
hide these menus only from a certain sheet called "my team KPIs"

Regards

"Bob Phillips" wrote:

Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB

Application.DisplayFormulaBar = mFormulaBar


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Pietro" wrote in message
...
Ok,now it's working fine,but how can i make it appear again
Thanx


"Bob Phillips" wrote:

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i
run
my
excel sheet ??

Hi Bob
This code is along the lines of what I need but is there a way of modifying
it so that the FILE/MENU/EDIT/etc menu bar is still shown and one other
toolbar (one that I will create).
Thanks,
Rob

"Bob Phillips" wrote:

I did, in your previous post.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pietro" wrote in message
...
Hi all,

Could any body tell me hw to hide the menubars and toolbars once i run my
excel sheet ??