PDA

View Full Version : [SOLVED] Sheeting Permissions



DarrylW
06-29-2005, 08:48 AM
Is it possible to only give select people access to a sheet in a work i.e. if I wanted John Williams to have access sheet1 but hide it from anyone else who tries to access it? but everyone is still allowed access to sheet 2

Jacob Hilderbrand
06-29-2005, 09:53 AM
Check out this Kb Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=33).

sheeeng
06-29-2005, 07:09 PM
Check out this Kb Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=33).

Great KB, Jake! :thumb

DarrylW
06-30-2005, 01:43 AM
Thanks DRJ.....

Just what I was looking for

excelliot
06-30-2005, 05:45 AM
hi Jack

can u tell me where password to be given in macro

will it be visible to anybody who see it

if yes than how to hide it?

Bob Phillips
06-30-2005, 05:47 AM
hi Jack

can u tell me where password to be given in macro

will it be visible to anybody who see it

if yes than how to hide it?

As explained in an earlier question, if you throw up a userform with a textbox, the textbox has a passwordchar property which you can set, and it echoes that back rather than what is entered.

excelliot
07-03-2005, 11:04 PM
hi
can u send me yr file after making chanfe to file supplied by DRj

i am unable to apply new username & password in macro