Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating custom menus
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 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating custom menus
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... -- HTH... Jim Thomlinson "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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
Custom menus don't appear under custom ribbon tab | Excel Programming | |||
Custom FaceID's for Custom Menus | Excel Programming | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
Creating Custom Menus | Excel Programming |