G
Guest
Guest
Hi!
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.
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.