Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm working on section access and the issue here is when i logged in as a user restricting properly but when i click the clear button it is showing the other user data as well.
Particularly when i click clear it is navigating to the restricted tab/sheet for the user
here I'm sharing the sample to analyse with login details
USERID PWD
SAI 123
AJITH 123
ADMIN 123
Any help is appreciable.
Regards,
Kishore.
Hi Nagaraj Thank you ....
using a macro for Save and Exit i'm able to achieve this
Added a macro like below to save and quit by checking as you suggested.
Initial Data Reduction Based On Section Access instead of Initial Selection Based on Section Access
so when ever user perform reload automatically the dashboard closed and user need to access again to see the data then this is getting restricted accordingly.
triggers > On post reload > assigned 'SaveAndQuit'
SUB SaveAndQuit
ActiveDocument.Save
ActiveDocument.GetApplication.Quit
END SUB
Hi,
Please find the attached file. I have done multiple changes.
1) Compare the script of your version of file and my version.
2) Check the show sheet expression.
3) You have to enable the below option in the document properties.
Thank you Nagaraj for the quick response.
Here when i reload the document as user with Initial data reduction based on section access checked instead initial selection based on section Access the other data as well reflecting here and tab access is not restricted here in your version.
For Information Purpose
This document is not deployed in server as the document is a OEM license leased not from the server leased license
Hi Nagaraj Thank you ....
using a macro for Save and Exit i'm able to achieve this
Added a macro like below to save and quit by checking as you suggested.
Initial Data Reduction Based On Section Access instead of Initial Selection Based on Section Access
so when ever user perform reload automatically the dashboard closed and user need to access again to see the data then this is getting restricted accordingly.
triggers > On post reload > assigned 'SaveAndQuit'
SUB SaveAndQuit
ActiveDocument.Save
ActiveDocument.GetApplication.Quit
END SUB
Hi Saikishore,
I'm glad you solved your problem and sorry I couldn't get time to check community so I was not able to help you. I like your idea. Have a fantastic day!