VBA: Allowed user

  • User friendly?? Who knows but I have colleagues that manage to do - anything (even though they shouldn't be able to)....


    Therefore I'm know wondering if it is possible to set users that are allowed to enter text in a sheet?


    I have a workbook were colleagues fill in data in 'their' sheet.
    Sheet names: "KES"; "KAD"; "LHA" etc...


    I'd like to set a parameter for each sheet which users are allowed to make changes whereas I "DOL" works as a "admin" and can make changes on all.
    E.g:
    Sheet named KES can be changed by: KES or LHA or DOL
    Sheet named KAD can be changed by: KAD or DOL
    Sheet named LHA can be changed by: LHA


    Other sheets not specified can be changed by any user.


    Is this possible?? Any ideas?


    All the best,
    /D

  • Hi RoyUK!
    Yes that is true - but if password protected then the document would need to 'automatically' protect the sheets when the workbook is closed (cause my dear colleagues would forget to choose protection when they are done... believe me!! :-))).


    Any input to achieve that?
    /Daniel

  • Hi Iridium!
    Followed instructions from your suggested link.


    Have created a sheet called "Welcome Screen" and also a sheet called "User List".


    My workbook contains 10 sheets (they are all listed in "User List".


    But when I close the book and open the welcome screen shows (all other are hidden) - all well so far...


    But then a error msg appears "Error nr '1004'" - saying the method 'Visible' in the object '_Worksheet' failed.


    Do you have any idea what can be wrong?


    Brgds,
    /Daniel

  • In the VBE which line of code is highlighted yellow when you run the code?

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • No line of code gets highlighted - it stops at just showing error msg no 1004: "Program- or objectdefined error".


    Even tried VBE and pressed 'play' but same error msg occurs - but no highlighted message. :(

Participate now!

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