limiting rows
 

I want to limit the sheet to 50 rows. How do I block the rest so that no one
could add new rows?

limiting rows
 

Would hiding them work for you?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Steph" wrote in message
...
I want to limit the sheet to 50 rows. How do I block the rest so that no
one
could add new rows?

limiting rows
 

no. I want to be able to edit or work only within the 50 rows but block from
adding for deleting the rows. How do I do that?

"Bernard Liengme" wrote:

Would hiding them work for you?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Steph" wrote in message
...
I want to limit the sheet to 50 rows. How do I block the rest so that no
one
could add new rows?

limiting rows
 

You might have to try using a custom designed Data Form to allow the user
to select a row of data and edit it. Put a button on the worksheet that
calls up this form and then protect the worksheet and workbook with a
password. When the user edits a row of data, your macro would temporarily
unlock the worksheet/workbook, change the cells for that row, then re-lock
the worksheet/workbook again.

--
Regards,
Bill Renaud