Section Access for different sheets in a document

[#1]

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

[#2]

You need to type in the following as a sheet-show-condition:

Uid = '02154'

[#3]

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...

[#4]

Select Sheet Properties -> General -> Under Show Sheet select Conditional and type the condition

[#5]

Thanks for that.

Any ideas what the condition would be in the syntax? Currently what I have is incorrect:

if (SUM(Uid)>='Ortho', Sheet.Visible)

[#6 · Accepted solution]

SUM(Uid)>='Ortho' would be enough under Conditional section

[#7]

Works fine now, thanks for that!