Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-02 Thread pankaj gmail account
sense to you. Cheers! AJ On Thu, May 2, 2013 at 9:30 AM, pankaj gmail account pankaji...@gmail.com wrote: in VBA Form. Regards, Pankaj Dear Priti, I want user restriction in Excel GUI form. Regards, Pankaj On Wed, May 1, 2013 at 4:30 PM, ravinder negi ravi_colw

$$Excel-Macros$$ Tricks to hide/restrict viewing excel data in sheets

2013-05-01 Thread pankaj gmail account
Dear Gurus, Please suggest ideas to hide/restrict data viewing in excel data sheets version 2007/2010. using VBA also. blocking right click, copy/paste, printing, saving, copy file, not able to view formula's etc. -- Thanks Pankaj Kumar 9910075248 -- Thanks Pankaj Kumar 9910075248 --

$$Excel-Macros$$ Curve Graph Help

2013-05-01 Thread pankaj gmail account
Dear Gurus how can i create Curve bell Graph with this data. Month - Failure in Month Year - Failure in Year Month Yr -2007 2008 2009 2010 2011 2012 2013 1 6 4 1 2 1 1 2 12 7 3 5 9 43 11 7 3 8 4 144 18 12 11 7 12 65 12 12 4 3 8 7 1 6 15 11 7 9 7 13 2 7 13 9 6 10 5 5 1 8

$$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread pankaj gmail account
-- Forwarded message -- From: pankaj gmail account pankaji...@gmail.com Date: Sat, Jan 5, 2013 at 9:10 AM Subject: Mandatory Cell Entry To: excel-macros@googlegroups.com Dear Gurus I want to make a excel data entry form in which i want some cells to be mandatory and some can

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread pankaj gmail account
to enter into columns of name. am i right or not. Regards, Priti verma On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account pankaji...@gmail.com wrote: -- Forwarded message -- From: pankaj gmail account pankaji...@gmail.com Date: Sat, Jan 5, 2013 at 9:10 AM Subject

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread pankaj gmail account
in VBA Form. Regards, Pankaj On Wed, May 1, 2013 at 4:30 PM, ravinder negi ravi_colw...@yahoo.comwrote: please give more detail with example file so we can understand properly whether you want this in VBA for or normally in excel sheet. --- On *Wed, 5/1/13, pankaj gmail account pankaji

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-20 Thread pankaj gmail account
Dear All, Pleae help to resolve the query. DEar Prince Please check On Tue, Jan 15, 2013 at 12:40 PM, pankaj gmail account pankaji...@gmail.com wrote: Dear Gurus Please help. Regards, Pnkaj On Thu, Jan 10, 2013 at 5:10 PM, Prince prince141...@gmail.com wrote: Ok Pankaj i can

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-14 Thread pankaj gmail account
Dear Gurus Please help. Regards, Pnkaj On Thu, Jan 10, 2013 at 5:10 PM, Prince prince141...@gmail.com wrote: Ok Pankaj i can only reply in evening. regards Prince On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote: Don't use differnt mails. REgards, Pankaj On Thu,

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread pankaj gmail account
Don't use differnt mails. REgards, Pankaj On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Prince, Its not working. Can you send me example with this formula. Rgds, Prabhakar On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote: yes it is

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-10 Thread pankaj gmail account
I have not received any answer. Regards, Pankaj On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account pankaji...@gmail.comwrote: Dear Prince and Lalit Thanks for response. what i wanted in a excel file:- Student ID Class SubjectMarks(Mandatory) 123

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-08 Thread pankaj gmail account
Dear Prince and Lalit Thanks for response. what i wanted in a excel file:- Student ID Class SubjectMarks(Mandatory) 123 V Maths 345 V Maths 123 V English 456

$$Excel-Macros$$ Mandatory Cell Entry

2013-01-04 Thread pankaj gmail account
Dear Gurus I want to make a excel data entry form in which i want some cells to be mandatory and some can be left out. But with sequence Like Name (Mandatory) Address (Mandatory) Phone ( not mandatory) *first field entry should be name, he cannot move to phone directly until name is filled. is

Re: $$Excel-Macros$$ Quiz results

2012-11-14 Thread pankaj gmail account
Good Quiz Keep it up. Hope more quizes. Pankaj Michel On Tue, Nov 13, 2012 at 11:59 PM, Ayush Jain jainayus...@gmail.com wrote: Dear group, Thanks for your participation in the quiz. There was very good response to the quiz from the members of this forum. Excel quiz : 250 responses VBA

Re: $$Excel-Macros$$ Combo [ Formula + Macro Bible] - [Prince 9953872217]

2012-10-14 Thread pankaj gmail account
Thanks On Sun, Oct 14, 2012 at 7:19 PM, SUDHIR VERMA newinex...@gmail.com wrote: thankx for sharing On 14 October 2012 10:23, Nikhil Shah nikhil201...@gmail.com wrote: Hi Thanks for sending excellent file, (1). Prince Formula Bible (Updated Version) (2). Updated Lets Learn Together (

$$Excel-Macros$$ Debuging VBA Programs

2012-08-22 Thread pankaj gmail account
Dear All, Please guide hw to Debug VBA Programs Regards -- Pankaj Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Excel Book Closed Macros

2012-07-31 Thread pankaj gmail account
Any Suggestions outlook is open but excel 2007 is closed. Regards Pankaj On Fri, Jul 27, 2012 at 4:28 PM, Pankaj pankaji...@gmail.com wrote: Dear Gurus, Can we create a macro or how can we send mails if my excel book is closed. like i have data:-- Name Email IDDate

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

2012-07-05 Thread pankaj gmail account
AM, joseph.cam...@gmail.com wrote: ** Hi Pankaj, Its an appreciation given to group members for helping. Correct me Ayush if I am wrong. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- *From: * pankaj gmail account pankaji...@gmail.com *Sender: * excel

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

2012-07-04 Thread pankaj gmail account
These kind of Congratulating etc Regards Pankaj On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: I just want to congratulate Ashish and Dilip. and contributions that you want two more forums. 2012/7/4 Ayush Jain jainayus...@gmail.com Pankaj, Please let me

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

2012-07-02 Thread pankaj gmail account
It is very Helpful -- Thank you for sharing Please upload more examples of Dashboards. Regards, Pankaj Michael On Fri, Feb 10, 2012 at 12:46 AM, resp...@gmail.com wrote: Its just historical stock market information for the Ghana stock exchange and major mkt indicators. But its the idea

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

2012-07-02 Thread pankaj gmail account
Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help. Please advice Thanks and Regads, Pankaj Michael On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

2012-06-21 Thread pankaj gmail account
: @Dear Noorain, In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5) all the sheets are hidden but links are working, can you please explain how to create this kind of file. Thanks in advance. Thanks Regards, Indrajit On Tue, Jun 19, 2012 at 10:15 PM, pankaj gmail

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

2012-06-19 Thread pankaj gmail account
Thanks You both Really they are great. We should share more sample Dashboards in Excel Regards Pankaj Michael On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ Re: MIS executive

2012-06-18 Thread pankaj gmail account
Hi To All, I also agree that we should also think about Job Posting in this forum. If a Needy gets Job with our help that's the best result of the forum. OK I also agree that this is not a Job Forum but instead of joining other Job forums we should think some alternative like we can use some

$$Excel-Macros$$ share Dashboard Examples/Templates

2012-06-18 Thread pankaj gmail account
Dear All, Please share Dashboard Examples/Templates I already viewed Chandoo's Site so no reference to that site. -- Pankaj Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ Double click Bar Charts

2012-05-21 Thread pankaj gmail account
Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five product bars. what i wants is when i click on product 2 bar i should get/open product 2 sales charts linked to it go on

Re: $$Excel-Macros$$ Double click Bar Charts

2012-05-21 Thread pankaj gmail account
you share the sample data On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account pankaji...@gmail.com wrote: Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five

Re: $$Excel-Macros$$ Download Access Tutorial

2011-10-23 Thread pankaj gmail account
link is not working Pankaj On Sun, Oct 23, 2011 at 9:24 PM, ashish koul koul.ash...@gmail.com wrote: http://www.susandoreydesigns.com/software/AccessTechniques.pdf -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. --

Re: $$Excel-Macros$$ Download Word Macro Tutorial

2011-10-23 Thread pankaj gmail account
This link is also not working. Pankaj On Sun, Oct 23, 2011 at 8:01 PM, ashish koul koul.ash...@gmail.com wrote: http://www.susandoreydesigns.com/software/WordVBATechniques.pdf -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the

Re: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message

2011-08-23 Thread pankaj gmail account
wrote: http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html try the attachment On Mon, Aug 22, 2011 at 8:21 PM, dguillett1 dguille...@gmail.com wrote: Sounds a bit like “homework” *From:* pankaj gmail account pankaji...@gmail.com *Sent:* Sunday, August 21, 2011 11

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

2011-08-21 Thread pankaj gmail account
Please forward same to me also Thanks Pankaj 2011/8/20 Venkat CV venkat1@gmail.com You are welcome *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn betnmtdongna...@gmail.comwrote: Thank venkat1@gmail.com has provided me the software

Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise

2010-10-05 Thread pankaj gmail account
Please help Pankaj On Sun, Sep 19, 2010 at 5:25 PM, pankaj gmail account pankaji...@gmail.comwrote: Hi to the forum, Please help me it is very urgent for me i have a text file which is (|) delimited in which it contains all countries files, what i want to do is to create country wise

$$Excel-Macros$$ pipe (|) delimited text file filtered country wise

2010-09-19 Thread pankaj gmail account
Hi to the forum, Please help me it is very urgent for me i have a text file which is (|) delimited in which it contains all countries files, what i want to do is to create country wise files in .TXT same format. so there will be singapore.txt india.txt etc. i tried but i was not able to