form

  • Thread starter Thread starter S
  • Start date Start date
S

S

I use form to input information into several columns on a
spreadsheet. I will be letting other people input and I
would like to lock the sheet so information can only be
entered thru the input form. How can I do this?

Thanks you in advance
 
How about putting a button from the forms toolbar on the worksheet and assigning
it this macro:

Option Explicit
Sub testme()

Dim wks As Worksheet
Set wks = Worksheets("sheet1")

With wks
.Unprotect Password:="hi"
Application.DisplayAlerts = False
.ShowDataForm
Application.DisplayAlerts = True
.Protect Password:="hi"
End With

End Sub

It unprotects, shows the data|form and then reprotects.

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.
 
Back
Top