Home

Help to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-792856%22%20slang%3D%22en-US%22%3EHelp%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792856%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20make%20a%20document%20which%20contains%20%223%20levels%22%20a%20bit%20like%20the%20already%20existing%20function%20where%20one%20can%20hide%20formulas%20for%20other%20users.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20I%20have%203%20groups%20of%20users%20who%20all%20needs%20different%20levels%20of%20access%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%3A%20can%20only%20read%20the%20document%20and%20not%20make%20any%20changes%20at%20all.%26nbsp%3B%3C%2FP%3E%3CP%3EB%3A%20can%20make%20changes%2C%20but%20the%20changes%20are%20not%20visible%20to%20A%20before%20they%20are%20approved%20by%20C.%26nbsp%3B%3CBR%20%2F%3EC%3A%20can%20make%20changes%20and%20approve%20changes%20made%20by%20C%20and%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20imagine%20that%20A%20can%20see%20like%20a%20frontpage%20with%20all%20the%20approved%20data.%20B%20can%20make%20changes%20in%20the%20data%2C%20add%20data%20or%20delete%20data%2C%20but%20the%20changes%20will%20not%20become%20visible%20to%20A%20before%20they%20are%20approved%20by%20C.%3C%2FP%3E%3CP%3EIt%20could%20be%20great%20with%20some%20kind%20of%20box%20where%20one%20can%20make%20%22a%20mark%22%20and%20in%20that%20way%20activate%20or%20deactivate%20what%20is%20visible%20to%20A%20but%20without%20losing%20it.%3CBR%20%2F%3ESo%20C%20have%20a%20palette%20of%20different%20data%3A%201%2C2%2C3%2C4%2C5.%20One%20day%20A%20is%20only%20allowed%20to%20see%20data%202%20and%204.%20Another%20day%20A%20is%20only%20allowed%20to%20see%20data%201%20and%205%20and%20the%20day%20after%20that%3A%203%20and%204.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20that%20possible%20to%20do%20in%20excel%3F%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-792856%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792895%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792895%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388500%22%20target%3D%22_blank%22%3E%40LineClemmensen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20possible%20but%20would%20require%20a%20lot%20of%20VBA%20and%20time%20to%20deliver%20correctly.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlmost%20sounds%20like%20B%20and%20C%20should%20have%20read%20a%20write%20access%20to%20one%20folder%20for%20draft%20documents%20then%20a%20read%20only%20copy%20is%20saved%20to%20an%20%22Approved%22%20folder%20by%20C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793033%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793033%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20your%20answer.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20plenty%20of%20time%2C%20but%20unfortunately%20haven't%20I%20tried%20VBA%20before.%20I%20have%20seen%20some%20youtube-videos%20though.%20But%20I%20guess%20this%20task%20requires%20more%20than%20a%20youtube-video...%20hehe.%3CBR%20%2F%3E%3CBR%20%2F%3EYes%2C%20you%20are%20on%20the%20right%20track%2C%20but%20I%20would%20like%20to%20have%20the%20opportunity%20to%20%22activate%20and%20deactivate%22%20what%20A%20see.%20If%20C%20saves%20a%20copy%20of%20the%20draft%20document%2C%20C%20would%20not%20be%20able%20to%20hide%20any%20data%20(e.g.%20%24E%248%3A%24H%2416)%20for%20A%3F%20right%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
LineClemmensen
New Contributor

Dear All

I want to make a document which contains "3 levels" a bit like the already existing function where one can hide formulas for other users. 

So I have 3 groups of users who all needs different levels of access:

 

A: can only read the document and not make any changes at all. 

B: can make changes, but the changes are not visible to A before they are approved by C. 
C: can make changes and approve changes made by C and B.

 

So I imagine that A can see like a frontpage with all the approved data. B can make changes in the data, add data or delete data, but the changes will not become visible to A before they are approved by C.

It could be great with some kind of box where one can make "a mark" and in that way activate or deactivate what is visible to A but without losing it.
So C have a palette of different data: 1,2,3,4,5. One day A is only allowed to see data 2 and 4. Another day A is only allowed to see data 1 and 5 and the day after that: 3 and 4. 


Is that possible to do in excel??

Thank you in advance.

 

Best regards

2 Replies

Hi @LineClemmensen 

 

It's possible but would require a lot of VBA and time to deliver correctly.

 

Almost sounds like B and C should have read a write access to one folder for draft documents then a read only copy is saved to an "Approved" folder by C

 

Hi @Wyn Hopkins 
Thanks for your answer. 

I have plenty of time, but unfortunately haven't I tried VBA before. I have seen some youtube-videos though. But I guess this task requires more than a youtube-video... hehe.

Yes, you are on the right track, but I would like to have the opportunity to "activate and deactivate" what A see. If C saves a copy of the draft document, C would not be able to hide any data (e.g. $E$8:$H$16) for A? right?