close

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 quot;securityquot;... 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...?

Thanksok nevermind, I found the solution.

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

quot;Dominicquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()