how to disable insert function wizard from the insert menu and from the formula bar
thankx
hesham
disable inserft function wizard
-
-
-
Hesham,
Try these two macros:
Private Sub Workbook_Open()
Application.CommandBars("Insert").Controls("Paste Function").Enabled = False
Application.DisplayFormulaBar = False
End SubPrivate Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Insert").Controls("Paste Function").Enabled = True
Application.DisplayFormulaBar = True
End SubThe only problem would be if they disable their macros, or have their security setting set "High", but there's a way around that as well.
Have a nice day...
Eugene -
Thank you Euge for your appreciated reply, however it did not work....and also i want to keep the formula bar but disable the (insert formula wizard function)
i have tried it in several ways............but barf::barf:
i did disable the insert menu as a whole menu, but i do not want this...............Private Sub Workbook_Open()
Application.CommandBars("&Insert").Controls("Paste Function").Enabled = False
Application.DisplayFormulaBar = False
End Subcould you and any one help
kind regards
hesham -
Hi Hesham
Try
Application.CommandBars.FindControl(ID:=385).Enabled = False
-
Thankx a lot
your code worked, but the function is disabled only in the insert menu and not disabled in the formula bar......
i want to disable it in the formula bar........kind Regards:)
-
Dave,
Most of what I've learned, I've learned from you and your web site....Thanks....
Where can I find a list of the control ID numbers? I use the name of the control right now, but that can become cumbersome.
Thanks for all you do for us...
Eugene -
-
Here you go...
XL97: List of ID Numbers for Built-In Command Bars
XL2000: List of ID Numbers for Built-In CommandBars
Hesham
Add this code to yours after you have hidden the formula bar
Application.CommandBars.FindControl(ID:=849).Enabled = False
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!