Hi Team,
The password is correct "STPIInvoices" in this up to STPII is CAPS letter
nvoices is small latters.
Please let me know if you have any questions on this.Thanks in advance.
*Private Sub cmdPrint_Click()
Set objDataSheet = Me.Parent.Sheets("Data")
objDataSheet.Unprotect "STPIInvoices"
Me.Unprotect "STPIInvoices"
PrintAllInvoices
objDataSheet.Protect "STPIInvoices", , , , , True, True, True, , True, ,
, True, True, True, True
Me.Protect "STPIInvoices", , , , , True, True, True
Set objDataSheet = Nothing
End Sub
*
On Wed, Jul 28, 2010 at 12:37 PM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Code is not opening, The password might be wrong.
>
> Kishan Reddy, K
>
> On Jul 27, 10:21 am, Nagendra Modupalli <naga14...@gmail.com> wrote:
> > Hi Team,
> >
> > I have Invoices printing macro.It is printing row wise.I want to modify
> > customer wise.Can you please help me.Thanks in advance.
> >
> > And also i have attached my macro file.
> >
> > For example if it is two columns same customer it has to print one
> invoice
> > and in this two column only it will change Invoice number and amt and i
> have
> > attached Example file.
> >
> > Password is STPIInvoices
> >
> > --
> > Thanks&Regards
> > Nagendra.M
> > Tel#91 9900516251
> >
> > --
> > Thanks&Regards
> > Nagendra.M
> >
> > "Beautiful photos are developed by negatives in a dark room, so if U see
> > darkness in Ur life believe that God is making a beautiful future for U
> !!!
> >
> > Macro_STPI Invoice(Annexures).zip
> > 1495KViewDownload
> >
> > Example.xls
> > 38KViewDownload
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks&Regards
Nagendra.M
"Beautiful photos are developed by negatives in a dark room, so if U see
darkness in Ur life believe that God is making a beautiful future for U !!!
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
