limiting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to limit the sheet to 50 rows. How do I block the rest so that no one
could add new 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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit worksheet for 50 rows only 6
Combine multiple worksheets in one Workbook into one big worksheet 6
Excel Is this possible?? 3
Excel Help to copy information from one row at a time to another sheet 1
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1
Converting Excel 2007 sheet back down to Excel 2003 1
rows in a table? 3
Paste in column B using Last row of either column B, C or D. 10

Back
Top