Auto Protect unblank cells, define users permissions and track changes

    Hi, i need help,


    I have a shared file on a work network, A specific users should be defined to access this file and give everyone of them a password and permissions.



    Required:
    1- After saving the file the unblank cells automatically locked and can't be edit.
    2- If sales man (user_1) write the code in column "C" ,the date of the transaction be filled automatically in column "A" in the same row of the Code.
    3- The date that was filled automatically in column "A" should be a value not a formula.
    4- Can track changes of the cells.
    5- Hide all sheet taps, menu, formula bar and make the window in full screen mode ,but show header of columns and rows.


    Thanks in advance.

    Re: Auto Protect unblank cells, define users permissions and track changes


    Quote from cytop;772479

    If I can ask - what have you tried to implement these 'requirements'?

    Of course you can, these implements were discussed with my manager if it possible to do these 'requirements' in excel and I have not any experience in VBA, So I post a thread here because I know that many of VBA's experts in this forum who can respond to my require.

    Re: Auto Protect unblank cells, define users permissions and track changes


    My first question would be if you have no experience with VBA why has your Manager given you this work to do? I think he is being unreasonable in the extreme.


    This is a help forum - we generally help people with problems. You have not posted a 'problem', you have posted a specification for work to be done. There's a big difference. Your workbook (even if it is saved as an XLSM file) does not contain any code so you are asking someone to start from scratch, build to your requirements, test the completed code and deliver to you. As with all build projects, there will be follow on questions, changes, or maybe something does not work as expected (maybe the 'requirements' were wrong in the first place). Invariably, once something is working, requests for other changes will follow.


    This thread, written as it is, should really be posted in the Hire Help forum. This is part of the forum where you offer to pay (the amount is down to you) for work that is outside the scope of the free forums. You will generally get a response within a couple of hours and probably a completed project in a day or 2.


    Tell your manager you can get someone to do this for you, quickly, cheaply (Perhaps USD$50 would be fair as requirement #4 is a little involved) and will support it, or make minor changes, for a short period after delivery.


    Other than that, this thread is not in the spirit of the free board. Also, there is a policy that each thread deals with 1 issue only so your 5 requirements take it outside that.


    However, if you want to start new threads for each of your requirements, you may. You might get lucky... but this is not somewhere to get your work done for free. Sorry.

    Re: Auto Protect unblank cells, define users permissions and track changes




    Sorry for wasting your time and posting thread in a wrong category.


    but about your question "Why my manager given me this work to do?" because i have a very good skills in excel specially formulas, pivot table, power query etc. so he depending on me in many problems and analysis in excel.


    thanks anyway, and i think i have to start learning VBA so if you know any channels on YouTube or PDFs may be useful for me to start from the beginning, i will be grateful to you.


    sorry for waste your time again


    regards

    Re: Auto Protect unblank cells, define users permissions and track changes


    Quote

    i have a very good skills in excel specially formulas, pivot table, power query


    That's good - but Excel formulas are not VBA.


    Yes, you should learn VBA, and the easiest way to learn is by writing a procedure that will do something you want - it's impossible to learn this from scratch with a book or YouTube (at least that's my opinion).


    So, do something you want...? The easiest of your 'requirements' is number 2 (Number 3 will follow from #2). If you want to jump right in then have a read of this page. That covers all you need to know about updating cells when another cell is changed. You also need to understand debugging, covered here by the same author.


    Have a read of those pages, try to write the code (it must be all of 6 or 7 lines to update Col A when Col C is changed) and then start another thread if you have problems. The fact you tried at least, and have some code to show even if it does not work - will guarantee a reply.


    Even if you do get it to work you can always post the code and ask for opinions, or if there's another way to do it...

    Re: Auto Protect unblank cells, define users permissions and track changes


    thanks for your help and thanks for the site, i found other useful topics i can use it in my work, I'll pursue on your Learning method.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login