Macro to insert new row in protected worksheet

**KoemansCC** · 01-11-2008, 02:39 AM

Hi folks,

I need a macro that will run from a command button ('New Entry') that will insert a new row into a worksheet. The new row will need to have the following properties:

- must be unprotected so that a user can enter data
- must have the same formating as the previous row (i.e. keep the dropdown lists)

I have attached an example of the excel sheet I will need the macro to run on, the protection password is 'x'.

Total n00b to VBA so all help appreciated,

K

**KoemansCC** · 01-17-2008, 01:32 AM

No need for worksheet to be protected...any tips appreciated

**davesexcel** · 01-17-2008, 02:00 AM

Originally Posted by KoemansCC

No need for worksheet to be protected...any tips appreciated

This seems to work in my xl 2003, copies the row from above including unlocking the cells

Please Login or Register  to view this content.

**Paul** · 01-17-2008, 02:12 AM

Hi KoemansCC,

Try this code attached to your button called 'NewEntry':

Please Login or Register  to view this content.

**KoemansCC** · 01-18-2008, 01:29 AM

Thanks for the quick reply guys, both methods work very well but there are slight niggles with both methods(very slight though).

Please Login or Register  to view this content.

The macro works excellent but when the new lines are added the cells contain all the properties bar the borders, is there a way to alter the macro so that the borders are included each time the command button is pressed.

Please Login or Register  to view this content.

This macro also works excellent but when I click the command button the new line is always inserted into the second row of the table after the first row and the entries are then listed in reverse order as follows

i.e
1st entry
... (new data entered here each time)
4th entry
3rd entry
2nd entry

This may not actually be an issue as it may be a clearer method of presenting the data and the first entry could be used as an example. but is there any method to list the data in sequential order.

i.e.
1st entry
2nd enty
3rd entry
...(new data entered here each time)

Thanks for the help so far, this really is an interesting forum...

Go raibh maith agat.
K

**KoemansCC** · 01-23-2008, 02:23 AM

Please Login or Register  to view this content.

The macro works excellent but when the new lines are added the cells contain all the properties bar the borders, is there a way to alter the macro so that the borders are included each time the command button is pressed.

Problem solved, I just put a border on cells B7:K7 and hid row 7 from view...

**dct** · 05-11-2015, 07:04 AM

Dear All,

Can I have the coding for insertion of row after the active cell? Further I did not want to insert the entire row, I just want to add cell from A7 : O7 or A:O whereever below the active cell.

regards
Dharmesh

**zbor** · 05-11-2015, 09:29 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.