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

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

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

Alt-F11

look at tools - VBAproject properties and check the lock project for viewing
box and then set a password.

Just a note of caution. Excel security isn't very robust.

"Afsha" wrote:

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

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

You have another (similar) response at your other thread.

Afsha wrote:

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

--

Dave Peterson