View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sameh Farouk Sameh Farouk is offline
external usenet poster
 
Posts: 3
Default 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