Hide and show sheets

[jduenyas]

Hi all

I wish to allow viewing or hiding certain sheets for certain viewers when they open QV.

Is it possible to have a macro that will hide a sheet or few named sheets based on a persons' login name?

Login name can be obtained with VBScript as such:

           Set objNetwork = CreateObject("Wscript.Network")
          CurrentUser = objNetwork.UserName

Thanks

[jagan · Accepted solution]

Hi,

You can easily do this by using Section Access, please find attached file for solution, refer file name for user names.

Regards,

Jagan.

[jduenyas]

Thank you.

I am using QV for 3 years now and quite savvy using it but never new about that.

Your help is appreciated.