View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] matthias.karl@gmail.com is offline
external usenet poster
 
Posts: 10
Default creating custom menus

On 12 Sep., 19:48, scott wrote:
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..._custom_menus/

Theres a good explanation on how to create menus.

Matthias