Remove element from menu

[Dominic]

Hello!

I'd like to remove some of the elements in the Tools menu for a specific
workbook but I don't how?

It a question of "security"... my spreadsheet is protected, but because I
unprotect it in a macro (and reprotected after), it keeps the password in
memory so when I go back and try to unprotect it (in the tools menu), it
doesn't prompt me the password box... If I remove this element of the menu it
should remove my problem...?

Thanks

[Dominic]

ok nevermind, I found the solution.

Just forget to put the password variable in my macro when in protect my
spreasheet....

"Dominic" wrote:

> Hello!
>
> I'd like to remove some of the elements in the Tools menu for a specific
> workbook but I don't how?
>
> It a question of "security"... my spreadsheet is protected, but because I
> unprotect it in a macro (and reprotected after), it keeps the password in
> memory so when I go back and try to unprotect it (in the tools menu), it
> doesn't prompt me the password box... If I remove this element of the menu it
> should remove my problem...?
>
> Thanks
>