| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable the Tool menu in toolbar
I have a workbook with severalworksheets,and many users use this workbook
I have a macro for protecting and unprotecting ,and disabling the users from deleting rows ,etc. but I found that some users have the security adjusted to high so macro is disabled and some others have the ability to go to macro and unprotect the sheet and also know the password,so is there a way to 1) when a user open the workbook,the security level adjusted to medium 2) the Tool menu in the menu bar be disabled Thanks to all for your help Best regards -- Sameh Farouk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable the Tool menu in toolbar
2)
application.CommandBars.Item("Tools").Enabled = False ' disables the dropdown application.CommandBars.Item("Tools").Visible =False ' hides the option "Sameh Farouk" wrote: I have a workbook with severalworksheets,and many users use this workbook I have a macro for protecting and unprotecting ,and disabling the users from deleting rows ,etc. but I found that some users have the security adjusted to high so macro is disabled and some others have the ability to go to macro and unprotect the sheet and also know the password,so is there a way to 1) when a user open the workbook,the security level adjusted to medium 2) the Tool menu in the menu bar be disabled Thanks to all for your help Best regards -- Sameh Farouk |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable the Tool menu in toolbar
Is there a way to do this with File "Save", but leave "Save As"
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable the Tool menu in toolbar
Yes!
Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Enabled = False ' Disable option Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Visible = False ' Hide option !Type "Save &AS..." as shown! "L Scholes" wrote: Is there a way to do this with File "Save", but leave "Save As" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable the Tool menu in toolbar
I think I disabled/made hidden Save AS instrad of Save;for Save use "&Save"
insead of "Save&AS..." within the code. "AA2e72E" wrote: Yes! Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Enabled = False ' Disable option Application.CommandBars.Item("File").Controls.Item ("Save &AS...").Visible = False ' Hide option !Type "Save &AS..." as shown! "L Scholes" wrote: Is there a way to do this with File "Save", but leave "Save As" |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disable the Tool menu in toolbar
If I disable .Item(&Save), will I still be able to use "Ctrl+S" to save?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable and Disable Tool Bar | Excel Programming | |||
| Hide/Disable Tool bar | Excel Programming | |||
| Disable Editing tool bars | Excel Discussion (Misc queries) | |||
| Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
| I am missing view tool bar from tool menu. | New Users to Excel | |||
Hybrid Mode
