Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable inserting or deleting row in selection of rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable inserting or deleting row in selection of rows
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable inserting or deleting row in selection of rows
To make sure you can change data on any cell place the following instruction
before the one I posted on my previous reply, something like this: Cells.Locked = False ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowInsertingRows:=True -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Michael" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable inserting or deleting row in selection of rows
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable inserting or deleting row in selection of rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |