ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Q about sheet protection (https://www.excelbanter.com/excel-discussion-misc-queries/235832-q-about-sheet-protection.html)

TheMilkGuy

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

Dave Peterson

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

TheMilkGuy

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




All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com