restricting access to a sheet on an app

[#1]

Hi,

Please see attached app.

I need to restrict the 'cost' tab so only I can see this.

Right in thinkig this can be done in sheet properties...

Chris

[stigchel · Accepted solution]

Hi Chris,

You can conditionally show the sheet based on the OSUser(). Create a text box with =OSUSER() to see what yours exactly is and use that in the conditional show. Anyone with access to the document properties (offline distribution) can however change this.

[m_woolf]

create a variable: vUserID

set it to: =upper(osuser())

Put the variable in a textbox so you can see what your userID looks like.

In the Condition show for the sheet, put:

=vUserID = 'Your userID'

[#4]

I have added this in but the sheet now dissapears. The conditional formatting should work so only I see it...

How do I get the sheet back?

[m_woolf]

If you do shift+ctrl+S you will see the hidden sheet.

The sheet shouldn't be hidden for you. Did you create the variable as I instructed? What did you put in the Conditional show for the sheet?

[#6]

Great, got it back.

I followed instruction from Piet as your hadn't come through.

Again sorry but how do you create a variable in the text box?

Chris

[m_woolf]

If you have created the vUserID variable and set it's value to: =upper(osuser()), all you need to put in the text box is:

=vUserID

[m_woolf]

You should do shift+ctrl+S again to hide the hidden objects. This is a toggle.

[#9]

how do I create the vUser ID variable?

[m_woolf]

Setting|Variable Overview|Add

Enter vUserID

Then select vUserID and type =upper(osuser()) in the Definition box.