Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, in excel 2003 you should be able to protect the worksheet, with the
following settings: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowInsertingRows:=False, AllowDeletingRows:=False The next statement, allows you to change the cell values(What you refer as editing): Cells.Locked = False -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Filips Benoit" wrote: So, protection that disables insert-row and delete-row but allows editing is NOT possible ! Filip "Michael" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting or Deleting Rows | Excel Programming | |||
Inserting/deleting rows between worksheets | Excel Worksheet Functions | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |