Protection password iin VBA, how to avoid user seeing it?

A

Afsha

I recently posted a question on how to be able to group and outline data in a
protected worksheeet. Dave Peterson gave me advise on the code need to be
entered into VBA to enable this. Which is now working.

I just want to ensure how can I now avoid a user of my protected worksheet
to not be able to hit alt-f11 and be able to se the password in the code? I
protected the workbook, however was still able to hit alt-f11 and see the
code which has the password.

thanks
Afsha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Object Browser in VBA 0
How to use/create code in MS Word to calculate age? 0
password protection problem 2
Code to format cells on several worksheets 2
WORD VBA Search and switch to advanced ... 1
Excel Mobile - password protection? 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0

Top