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
: dguil...@gmail.com
Subject: Re: $$Excel-Macros$$ How to 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
*Sender: * excel-macros@googlegroups.com
*Date: *Mon, 29 Dec 2014 16:30:00 +0530
*To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Cc: *dguil...@gmail.com
*Subject: *Re: $$Excel-Macros$$ How to insert new row in a protected
table formatted
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,