You can protect the sheet after the Database has been updated using the
following statement:


ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

This will allow selecting cells, but not inserting rows.


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Filips Benoit" wrote:

Dear All,

Is it possible to ensure that the use cannot insert or delete rows in the
first printed page ( rows 1 till 38 in my case).
Since there is a button that insert data from a SQL-database in the first
page this page shoud not be altered in number of rows but the user shoud
still be able to change cell-data!

Thanks,

Filip