How do you create a permanent input form in Excel?

Answer by  Priya7727 (6)

Use Visual Basic editor in Excel to insert a userform to input and accept data. Save the code in a file and set a trigger using macro to execute this userform.

Answer by  XTC46 (394)

It sounds like you want to create a form to send to people which they can fill out, save and send back. The best way to do this is to lock the cells you dont want changed with a password. The other cells can be changed by anyone.

Answer by  Jahid75 (30)

Creating a permanent input form in Excel is very easy. The easiest way is "to lock" all cells but the ones delegated to input than protect your worksheet and save the project. This way the user may only modify the blank fields you didnt lock, that's it: easy and effective!

Answer by  alsoftware (117)

The easiest way is "to lock" all cells but the ones delegated to input than protect your worksheet and save the project. This way the user may only modify the blank fields you didnt lock, that's it: easy and effective!

Answer by  soundarskpincom (30)

The easiest way is "to lock" all cells. This way the user may only modify the blank fields you didnt lock, that's it: easy and effective!

Answer by  saranya88 (3)

First we will type the matter into the excel sheet columnwise based (e.x) Name of the student,subjects,marks and etc., and put the marks into the cells and you will calculate the marks int autosum method and you will save the sheets into the computer.

Answer by  gigo (1706)

Select the cells you want to be with permanent values. Then select the option lock cells in the context menu.

Answer by  japratt (1687)

If you want to create a permanent input for your Excel program you will need to save it to a certain file.