Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Limiting my users freedom!

  1. #1



    Have created a workbook where my users can select year, month, day etc via drop down lists and press different buttons to get certain charts presented. I don't want the users to be able too see anything but the sheets containing the charts and buttons.

    How I protect my workbook so the users can only use the prepared dropdown lists and buttons (not editing anything themselves!). I don't want them to be able so save, type or anything but still want my macros to be able to execute, create charts etc.. Any ideas how to do this?

    Thanks in Advance / Jokklas.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Sunny, spring-like Hull
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    Protecting each of your worksheets (make sure the cells are formatted as locked) with a passsword will prevent users from modifying them. Protecting your workbook will prevent them adding, deleting or moving sheets around. You can also protect and share the workbook, so that if anyone does manage to make a change, you have a history of who does what and you can also lock the VBA project for viewing. HTH.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts