Re: $$Excel-Macros$$ How to insert new row in a protected table formatted sheet

2014-12-29 Thread Vaibhav Joshi
excel-macros@googlegroups.com > *Date: *Mon, 29 Dec 2014 16:30:00 +0530 > *To: *excel-macros@googlegroups.com > *ReplyTo: * excel-macros@googlegroups.com > *Cc: * > *Subject: *Re: $$Excel-Macros$$ How to insert new row in a protected > table formatted sheet > > Hey Victor, > > C

Re: $$Excel-Macros$$ How to insert new row in a protected table formatted sheet

2014-12-29 Thread meetgoni
insert new row in a protected table formatted sheet Hey Victor, Check this... There is 2 separate macro for inserting row & deleting row... While inserting row first you need to enter how many rows to be inserted & then select cell after which rows to be inserted.. For deleting row you

Re: $$Excel-Macros$$ How to insert new row in a protected table formatted sheet

2014-12-29 Thread Vaibhav Joshi
Hey Victor, Check this... There is 2 separate macro for inserting row & deleting row... While inserting row first you need to enter how many rows to be inserted & then select cell after which rows to be inserted.. For deleting row you will be prompted for selecting cell for which you need to de

$$Excel-Macros$$ How to insert new row in a protected table formatted sheet

2014-12-28 Thread Victor Goni
I need a VBA Macro that could insert new row or delete row in a protected table formatted sheet (as attached). when sheet is unlocked i can isert a new row by pressing the tab button. I need a VBA Macro that could enable my users add more items purchased when the editable rows are insufficient,