ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I make fill-in-the-blank forms, with Excel? (https://www.excelbanter.com/new-users-excel/105075-how-do-i-make-fill-blank-forms-excel.html)

Raymond Mayo RJM ENT.

How do I make fill-in-the-blank forms, with Excel?
 
I'm new to Windows, and I have no idea how to create a fill-in-the-blank
style program using Windows XP, and Microsoft Office (Excel). I think I'm
going in the right direction with Excel, but every time I protect a cell, I
can change the info with a double click. It's like the protection isn't even
there, What's up? I need HELP! Is there something that I'm doing, (or not
doing) that will make this form work?

Dave Peterson

How do I make fill-in-the-blank forms, with Excel?
 
How are you protecting the cell?

Format|Cells|Protection tab|check locked

But then you have to protect the worksheet.

tools|Protection|protect sheet
Give it a nice password.

(These passwords are easily broken--so don't assume your data is in Fort Knox!)

Raymond Mayo RJM ENT. wrote:

I'm new to Windows, and I have no idea how to create a fill-in-the-blank
style program using Windows XP, and Microsoft Office (Excel). I think I'm
going in the right direction with Excel, but every time I protect a cell, I
can change the info with a double click. It's like the protection isn't even
there, What's up? I need HELP! Is there something that I'm doing, (or not
doing) that will make this form work?


--

Dave Peterson


All times are GMT +1. The time now is 05:15 AM.

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