To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code for inserting a row in table in
protected sheet
I am Zero in VBA Macros but attracted toward them just because i know excel
formulas has limitations.
I want to understand the code written by Noorain Bhai..,,
Secondly, the
lle...@gmail.com
>>
>> *From:* NOORAIN ANSARI
>> *Sent:* Friday, July 06, 2012 7:02 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ VBA Code for inserting a row in table in
>> protected sheet
>>
>> Dear BS,
>
ftware
> dguille...@gmail.com
>
> *From:* NOORAIN ANSARI
> *Sent:* Friday, July 06, 2012 7:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VBA Code for inserting a row in table in
> protected sheet
>
> Dear BS,
>
> Please t
ent: Friday, July 06, 2012 7:02 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code for inserting a row in table in
protected sheet
Dear BS,
Please try it, change some line as per your exact need.
Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQu
Dear BS,
Please try it, change some line as per your exact need.
Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox("Enter number of rows to insert", "Your Call")
If InsQuan <= 0 Then
MsgBox "Invalid number entered", vbCritical, "Stop!"
Exit Sub
End If
Applica
Dear Excel Experts,
I have a protected data sheet, where I want to insert row where the cursor
is selected.
I need a VBA code who will do the following:
1. Unprotect the sheet (with password)
2. Insert a row in the table where the cursor is pointed.
3. Protect the sheet (with password)
I need
