Get USERNAME then IF Routine on Excel

[liamm]

Hi,
I require a way to only show a worksheet if 2 designated users log on on their networked PC's. I think I would use the Get username routine but get stuck with how to use this username to perform an IF routine to show the specific worksheet.
Any alternative method would considered
Thanks

If you can help, GREAT
If I can help, EVEN BETTER

 

[Chance1234]

you could put it in worksheet on open events

return the user name

if username = XXXXX then
Sheet1.Visible = xlSheetHidden
sheet2.visible = xlsheetvisible
elseif username = AAAAAA then
Sheet1.Visible = xlsheetvisible
sheet2.visible = xlSheetHidden
end if





Chance,

Filmmaker, gentleman and up for parole shortly

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK

 

[Molby]

If you are using this as security I would use xlSheetVeryHidden.