lock columns A to G for manual data entry but let my userform fill in columns A to G only

[MrGuard2015]

Hope some one can help me

i have spreadsheet set up which is filled in by a userform what i would like to do is the following
i want to the data to be enterd by my userform only not by some on selecting the cells manually
can this be done
i would like any help if possible

thanks in advance

[mikerickson]

One way would be to use DataValidation on columns A:G with the formula =FALSE. (Uncheck the Ignore Blanks)

Then the user couldn't type in entries, but the VB associated with a user form could.

Howerver (not mentioned in the OP) the use could copy a cell a paste it into a cell in A:G.