Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have my section acces loaded into the script, however I'd like to be able to write a simple conditional statement in each sheet property granting user acces. For example,
if
(Uid = '02154', Show(Sheet))Is anyone aware of such a statement? Thanks
You need to type in the following as a sheet-show-condition:
Uid = '02154'
Thanks for the reply.
I have Uid declared in my script already (below).
I was thinking of going for something like this but obviously i'm lacking the correct syntax.
(if
(Uid) <> 'Ortho', RemoveSheet),-------------------------------------------------------------------------------------------------------------
Load
[ACCESS][USERID]
As Uid
[PASSWORD]
OMIT
FROM
[\\PE...Select Sheet Properties -> General -> Under Show Sheet select Conditional and type the condition
Thanks for that.
Any ideas what the condition would be in the syntax? Currently what I have is incorrect:
Works fine now, thanks for that!