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 |
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 |
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 |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com