| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q about sheet protection
Hi folks,
I am using Excel 2007 and have a page that I have always used "Allow Users to Edit Ranges" on. I have recently added two checkboxes (Form Controls) to that page but I cannot figure out how to use the checkboxes when I have the page protected. Suggestions welcome. Many thanks! Craig |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q about sheet protection
If you're linking those checkboxes to cells, make sure those cells are unlocked.
TheMilkGuy wrote: Hi folks, I am using Excel 2007 and have a page that I have always used "Allow Users to Edit Ranges" on. I have recently added two checkboxes (Form Controls) to that page but I cannot figure out how to use the checkboxes when I have the page protected. Suggestions welcome. Many thanks! Craig -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q about sheet protection
FASCINATING!
Thank you very much! A perfect solution. Cheers, Craig On Jul 4, 11:25*am, Dave Peterson wrote: If you're linking those checkboxes to cells, make sure those cells are unlocked. TheMilkGuy wrote: Hi folks, I am using Excel 2007 and have a page that I have always used "Allow Users to Edit Ranges" on. *I have recently added two checkboxes (Form Controls) to that page but I cannot figure out how to use the checkboxes when I have the page protected. Suggestions welcome. *Many thanks! Craig -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet protection | Excel Discussion (Misc queries) | |||
| Sheet protection | Excel Discussion (Misc queries) | |||
| Sheet protection on MAC | Excel Discussion (Misc queries) | |||
| Sheet Protection | Excel Worksheet Functions | |||
| Sheet Protection | Excel Discussion (Misc queries) | |||
Linear Mode
