Limiting my users freedom!

Mar 8th, 2002, 06:02 AM

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.

Mudface · Mar 8th, 2002, 06:39 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 06:02 AM	#1
Guest Posts: n/a	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.

Mar 8th, 2002, 06:39 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.