creating custom menus

[scott]

I have a two part question.
1. Is it possible to make a custom menu bar?
2. If it is how do you do it. I can not write VB code. All I need is
Under File
Save
Save As
Print Preview
Print
Send To
Open Close
New
Under Edit
Copy
Past
Undo
Redo
Under Tools
Protection
sheet and Workbook
My reason for this custom menu bar is employees are consitently changing
settings under the tools options tab. Or if anyone has another suggetsion.
Passwording Excel does not keep them out of this options tab.

Thanks Scott

 

[matthias.karl]

I have a two part question.
1. Is it possible to make a custom menu bar?
2. If it is how do you do it. I can not write VB code. All I need is
Under File
Save
Save As
 Print Preview
Print
Send To
Open Close
New
Under Edit
Copy
Past
Undo
Redo
Under Tools
Protection
sheet and Workbook
My reason for this custom menu bar is employees are consitently changing
settings under the tools options tab. Or if anyone has another suggetsion..
Passwording Excel does not keep them out of this options tab.

Thanks Scott

Scott

Have a look at http://spreadsheetpage.com/index.php/site/tip/creating_custom_menus/

Theres a good explanation on how to create menus.

Matthias

 

[Jim Thomlinson]

There is no effective way to do what you are asking. It is kind of like
giving the car keys to your teenager. You can teach them how to drive. You
can tell them not to speed. You can even tell them where they are and are not
allowed to go. But once they have the keys it is all up to them. The can go
where they want, as fast as they want and there is pretty much nothing you
can do about it... Some will do what they are told. Some won't...