"autoexec" is the macro that works once the sheet is open,i guess,please
write the exact codes that i shouyld use as i'm not experienced enoujgh with
Excel..
Regards

"Bob Phillips" wrote:

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 ??