VB Forms

[jsambrook]

I have a list of data that I can open as a form. I would like to run a macro to request the user inserts data into the form. However, I dont want them to have to go to "New" and then insert the data. Is there a way to open the form at a New record? I also dont want them to be able to alter any of the existing data.
Thanks

 

[sijpie]

Not altering the existing data is the easy part. Just lock the spreadsheet with a password and the user can't change it.
However when you want to change the sheet (through the macro) yu will first need to unlock the sheet, add the new data, and the lock the sheet again.

private const MySheetPW = "DadiDah"
 
Sub test()
 UnProtectSheet Worksheets("Sheet1")
End Sub
 
Sub ProtectSheet(WS As Worksheet)
    With WS
        .Protect Password:=MySheetPW, DrawingObjects:=True, _
            Contents:=True, Scenarios:=True, _
            userinterfaceonly:=True, AllowFiltering:=True, AllowUsingPivotTables:=True
    End With
End Sub
 
Sub UnProtectSheet(WS As Worksheet)
    WS.Unprotect Password:=MySheetPW
End Sub

But I am not sure what you mean with your first request that the user does not need to got to 'New'. How should Excel then decide to open the userform. Or is it always open as soon as the workbook opens? But then how cna the user do anything useful with the data once it is entered. More explanation please