date:20110622

Re: $$Excel-Macros$$ I want customised web query in excel

2011-06-22 Thread sharad jain

I have alread tried that.

I have put date range as 1-Jun-2010 to 21-Jun-2011.

On Wed, Jun 22, 2011 at 9:17 PM, ashish koul  wrote:

> chage the date  in cell d2 and f2
>
> and client in b2 and then run the macro
>
>
> On Wed, Jun 22, 2011 at 7:35 PM, sharad jain wrote:
>
>> Thanks Ashish,
>>
>> But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.
>>
>> Also can you please let me know how create this type of macro?
>>
>> Thanks,
>> Sharad
>>
>>   On Wed, Jun 22, 2011 at 7:18 PM, ashish koul wrote:
>>
>>> try this
>>>
>>>
>>> On Wed, Jun 22, 2011 at 5:59 PM, Ketan  wrote:
>>>
  Dear Members,

 ** **

 I have attached file which has macro to fetch data from NSE website ***
 *

 ** **

 In that I want that query to be customized like date range to change and
 company name also changed 

 So that I can fetch data in excel by changing date range and symbol

 ** **

 Ketan Yadav

 ** **

 --

 --
 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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> http://akoul.posterous.com/
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

$$Excel-Macros$$ Macro causing drawing objects to be deleted

2011-06-22 Thread 0 1

A macro used to delete empty rows and assign some values on multiple 
worksheets is, for some reason, also deleting all drawing objects (e.g., 
textboxes, lines, etc.) in the workbook. The problem only occurs on one PC 
(the user just got 2007 installed). (When she was using 2003 the macro 
worked fine.) I tested the macro on other PCs with 2007 and it works fine. 
So I suspect this user has some particular setting in her new Excel install 
that's contributing to the problem. Any suggestions where to look? 

The objects are on the sheet before she runs the code, but after she runs it 
the objects are gone. The worksheet and macro were created in 2003, and she 
(just like all other users) is opening it in compatibility mode. But the 
problem happens for her whether she uses the .xls version or the .xlsm 
version. 

Because it works fine on all other PCs, I doubt it's the macro, but just in 
case the macro simply:

1. Activates the first sheet
2. Deletes rows that meeting a certain criteria (EntireRow.Delete)
3. Assigns some values to some named ranges (Range("MyCell").Value = 
intSomeVariable defined earlier

Any idea what setting on her computer / Excel installation might cause this 
behavior?

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Dynamic Lookup Secrets is LIVE!

2011-06-22 Thread Ayush

Dear Group,
 
Only 2 days left. 

On Tuesday, 21 June 2011 23:35:38 UTC+5:30, Ayush wrote:

> Dear members,
>  
> Hope you are doing great ! 
>  
> This is very exciting news !
>
> John Franco has just opened enrollment for his premium online private 
> coaching program "Dynamic Lookup Secrets"
>
> It is packed with amazing content that you will LOVE. I have personally 
> reveiwed the material and it is fantastic and you WILL be helped.
> Click HERE to get started 
>
> After seeing how great this material is, I honestly don't think you can 
> afford to NOT at least try it out.
> The value is so much more than the asking price and you should invest in 
> yourself and take action now
>
> Invest in your career NOW 
>  
> The product just went live, and he expects there to be lots of traffic 
> today, so head on over to the page below and reserve your spot. 
> Let me know if you have any queries. The program is open till 24th June
>  
> Countdown starts..
>
> Thanks for your time,
> Ayush Jain
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Excel task

2011-06-22 Thread ashish koul

going forward post your query on the group


Sub test()
Dim i As Long

For i = Sheets(1).Range("a65356").End(xlUp).Row To 2 Step -1
Sheets(1).Select
If Sheets(1).Cells(i, 4).Value = 0 Then

Sheets(1).Cells(i, 4).EntireRow.Delete
End If



If Now() - CDate(Sheets(1).Cells(i, 3).Value) > 90 Then

Rows(i & ":" & i).Copy

Sheets("Above 90 Days").Select
Range("a65356").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste

ElseIf Now() - CDate(Sheets(1).Cells(i, 3).Value) > 60 Then


Rows(i & ":" & i).Copy

Sheets("Above 60 days").Select
Range("a65356").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
ElseIf Now() - CDate(Sheets(1).Cells(i, 3).Value) > 30 Then


Rows(i & ":" & i).Copy

Sheets("Above 30 Days").Select
Range("a65356").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
End If


Next i

Sheets("Above 90 Days").Range("a1:j" & Range("a1").End(xlDown).Row).Sort
key1:=Sheets("Above 90 Days").Range("a:a"), order1:=xlAscending,
Header:=xlYes
Sheets("Above 30 Days").Range("a1:j" & Range("a1").End(xlDown).Row).Sort
key1:=Sheets("Above 30 Days").Range("a:a"), order1:=xlAscending,
Header:=xlYes
Sheets("Above 60 days").Range("a1:j" & Range("a1").End(xlDown).Row).Sort
key1:=Sheets("Above 60 days").Range("a:a"), order1:=xlAscending,
Header:=xlYes


End Sub


On Wed, Jun 22, 2011 at 7:23 PM, Manish Bankoti
wrote:

>
> Hi Ashish,
>
>  I want data from sheet 1 to copy and paste it in other sheets as per the
> date also they will sort automatically in other sheets and data in sheet1
> whose amount is 0 should be deleted.
>
> Thanks & Regards,
> Manish Singh Bankoti
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-22 Thread ashish koul

try this

http://peltiertech.com/Excel/Charts/

On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Pleaase can I get 2007 code to get good looking chart as 2003. Thanks!
>
> On Wed, Jun 22, 2011 at 2:04 PM, ashish koul wrote:
>
>> Sub check()
>> If Application.Version = "12.0" Then
>>
>>
>> ' code for 2007
>>End If
>>If Application.Version = "11.0" Then
>>'code for 2003
>>
>> End If
>> End Sub
>>
>>
>>
>>
>>
>>
>>
>>
>> On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Can we write different code do this. Where VBA code knows which version
>>> user is using according to that it changes chart plot area. If yes please
>>> let me know. Thanks!
>>>
>>> On Wed, Jun 22, 2011 at 12:34 AM, Daniel  wrote:
>>>
  Charts are quite different with Excel2007, so you have to resize the
 plot area, change the series colors in order to get something similar. I 
 use
 Excel 2010 which is still different from Excel 2007.

 ** **

 Daniel

 ** **

 *De :* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *De la part de* Chandra Shekar
 *Envoyé :* mardi 21 juin 2011 07:49

 *À :* excel-macros@googlegroups.com
 *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

   ** **

 Hi,

  

 Graph output is different compare to 2003 and 2007. I have pasted both
 the graphs in "Analysis Sheet". 2003 Ouput is that which is produced in 
 2003
 which is perfect, but 2007 output which is pasted just below the data is
 generated in 2007 which is not as 2003 output. 

  

 Please run this code in both 2003 and 2007 you can find the difference.
 

  

 Thanks,

  

 Chandra Shekar

 On Mon, Jun 20, 2011 at 11:46 PM, Daniel  wrote:**
 **

 Hi,

  

 Can you ell which macro is involved and which result is different ?

  

 Regards.

 Daniel

  

 *De :* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *De la part de* Chandra Shekar
 *Envoyé :* lundi 20 juin 2011 10:19 


 *À :* excel-macros@googlegroups.com

 *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code 

  

 Hi,

  

 I am getting different output in 2003 & 2007 I gave pasted that in
 attached workbook. Please let me know if you have any queries regarding
 this. Thanks!

  

 Regards,

  

 Chandra Shekar B

  



  

 On Sat, Jun 18, 2011 at 12:05 AM, Daniel  wrote:**
 **

 Hi,

  

 I don’t think there are tool to automate the processbecause the syntax
 is very similar. Can you post your code and tell which line produces the
 error ?

  

 Regards.

 Daniel

  

 *De :* excel-macros@googlegroups.com [mailto:e
 xcel-mac...@googlegroups.com] *De la part de* Chandra Shekar
 *Envoyé :* vendredi 17 juin 2011 10:13
 *À :* excel-macros@googlegroups.com
 *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code

  

 Hi,

  

 How to convert 2003 VBA code to 2007, because some of codes what I am
 running in 2003 is not running in 2007. Is there any way to convert this to
 any office to get the same result.

  

 I am getting following error... Run-time error '-2147467259
 (84005'):
 The specified dimension is not valid for the current chart type. 

 Thanks,

  

 Chandra Shekar B

 --

 --
 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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN g

Re: $$Excel-Macros$$ I want customised web query in excel

2011-06-22 Thread ashish koul

chage the date  in cell d2 and f2

and client in b2 and then run the macro


On Wed, Jun 22, 2011 at 7:35 PM, sharad jain  wrote:

> Thanks Ashish,
>
> But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.
>
> Also can you please let me know how create this type of macro?
>
> Thanks,
> Sharad
>
> On Wed, Jun 22, 2011 at 7:18 PM, ashish koul wrote:
>
>> try this
>>
>>
>> On Wed, Jun 22, 2011 at 5:59 PM, Ketan  wrote:
>>
>>>  Dear Members,
>>>
>>> ** **
>>>
>>> I have attached file which has macro to fetch data from NSE website 
>>>
>>> ** **
>>>
>>> In that I want that query to be customized like date range to change and
>>> company name also changed 
>>>
>>> So that I can fetch data in excel by changing date range and symbol
>>>
>>> ** **
>>>
>>> Ketan Yadav
>>>
>>> ** **
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

2011-06-22 Thread Vasant

pls try this

Sub locksheet()
Dim DataRng As Range, DataFilledRange As Range
Dim WkSht As Worksheet
Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:F7")
Set WkSht = ThisWorkbook.Worksheets("April")
WkSht.Unprotect
With WkSht.Cells
  .Locked = fase
  .FormulaHidden = False
End With
For Each cls In DataRng
If cls.Value <> "" Then
If WorksheetFunction.CountA(WkSht.Range(Cells(3, cls.Column), Cells(3 +
DataRng.Rows.Count - 1, cls.Column))) <> DataRng.Rows.Count Then
If DataFilledRange Is Nothing Then
Set DataFilledRange = cls
Else
Set DataFilledRange = Application.Union(DataFilledRange, cls)
End If
End If
End If
Next cls
With DataFilledRange
  .Locked = True
  .FormulaHidden = True
End With
WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

On Wed, Jun 22, 2011 at 7:28 PM, Rajesh K R wrote:

> Hi Vasant
>
> Thanks for the code, its working well I need a condition in this the
> columns must not be locked in case all the data entry cells filled eg;
>  A  B C  D E  F  G H  I
> S N NAME1   2   3   4   5   6   7
> 3   3   3   1   0   0   0   0
> 1   RAJESH  X   X   X
> 2   SANUX   X
> 3   ANILX   X
>
> Here in column C & D have full data so it have to be locked, but
> column"E" don't have full data so it should remain unlocked till it
> finished the data entry.Row 3 have counting formula & Cell "A3" have
> the max formula. u can compare them for
>
>Range("b2").Select
>ActiveCell.Offset(0, 1).Select
>Application.ScreenUpdating = False
>ActiveSheet.Unprotect Password:="rajesh"
>If ActiveCell.Text <> Range("a2").Text Then
>ActiveCell.Offset(0, 1).Select
>Else
>ActiveCell.EntireColumn.Locked = True
>ActiveSheet.Protect Password:="rajesh"
>End If
>Application.ScreenUpdating = True
>
> The code explain my idea about locking, but I don't to know how to
> make a loop .Pls consider this also & modify the code.
>
> Regards
> Rajesh Kainikkara
>
>
> On 6/22/11, Vasant  wrote:
> > pls try this
> >
> > this will lock the populated cells in the range C3:AA5 in sheet 'april'
> >
> > Sub locksheet()
> > Dim DataRng As Range, DataFilledRange As Range
> > Dim WkSht As Worksheet
> > Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:AA5")
> > Set WkSht = ThisWorkbook.Worksheets("April")
> > WkSht.Unprotect
> > For Each cls In DataRng
> > If cls.Value <> "" Then
> > If DataFilledRange Is Nothing Then
> > Set DataFilledRange = cls
> > Else
> > Set DataFilledRange = Application.Union(DataFilledRange, cls)
> > End If
> > End If
> > Next cls
> > With DataFilledRange
> >   .Locked = True
> >   .FormulaHidden = True
> > End With
> > WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> > End Sub
> >
> > On Wed, Jun 22, 2011 at 3:54 PM, Rajesh K R
> > wrote:
> >
> >> Hi Experts
> >>
> >> I add a code in the work sheet for the identification of data
> >> selected, But the copy paste is not working in that sheet. How can I
> >> solve the issue,Pls check the code & tell me the change required.
> >>
> >> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> >> Application.EnableEvents = False
> >> Columns(2).Interior.ColorIndex = 15
> >> Cells(ActiveCell.Row, 2).Interior.Color = vbYellow
> >> Application.EnableEvents = True
> >> End Sub
> >>
> >> Regards
> >> Rajesh Kainikkara
> >>
> >> --
> >>
> >>
> --
> >> 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
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >
> >
> >
> > --
> > Regards
> >
> > Vasant
> >
> > --
> >
> --
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below lin

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-22 Thread Chandra Shekar

Pleaase can I get 2007 code to get good looking chart as 2003. Thanks!

On Wed, Jun 22, 2011 at 2:04 PM, ashish koul  wrote:

> Sub check()
> If Application.Version = "12.0" Then
>
>
> ' code for 2007
>End If
>If Application.Version = "11.0" Then
>'code for 2003
>
> End If
> End Sub
>
>
>
>
>
>
>
>
> On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Can we write different code do this. Where VBA code knows which version
>> user is using according to that it changes chart plot area. If yes please
>> let me know. Thanks!
>>
>> On Wed, Jun 22, 2011 at 12:34 AM, Daniel  wrote:
>>
>>>  Charts are quite different with Excel2007, so you have to resize the
>>> plot area, change the series colors in order to get something similar. I use
>>> Excel 2010 which is still different from Excel 2007.
>>>
>>> ** **
>>>
>>> Daniel
>>>
>>> ** **
>>>
>>> *De :* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar
>>> *Envoyé :* mardi 21 juin 2011 07:49
>>>
>>> *À :* excel-macros@googlegroups.com
>>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
>>>
>>>   ** **
>>>
>>> Hi,
>>>
>>>  
>>>
>>> Graph output is different compare to 2003 and 2007. I have pasted both
>>> the graphs in "Analysis Sheet". 2003 Ouput is that which is produced in 2003
>>> which is perfect, but 2007 output which is pasted just below the data is
>>> generated in 2007 which is not as 2003 output. 
>>>
>>>  
>>>
>>> Please run this code in both 2003 and 2007 you can find the difference.*
>>> ***
>>>
>>>  
>>>
>>> Thanks,
>>>
>>>  
>>>
>>> Chandra Shekar
>>>
>>> On Mon, Jun 20, 2011 at 11:46 PM, Daniel  wrote:***
>>> *
>>>
>>> Hi,
>>>
>>>  
>>>
>>> Can you ell which macro is involved and which result is different ?
>>>
>>>  
>>>
>>> Regards.
>>>
>>> Daniel
>>>
>>>  
>>>
>>> *De :* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar
>>> *Envoyé :* lundi 20 juin 2011 10:19 
>>>
>>>
>>> *À :* excel-macros@googlegroups.com
>>>
>>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code 
>>>
>>>  
>>>
>>> Hi,
>>>
>>>  
>>>
>>> I am getting different output in 2003 & 2007 I gave pasted that in
>>> attached workbook. Please let me know if you have any queries regarding
>>> this. Thanks!
>>>
>>>  
>>>
>>> Regards,
>>>
>>>  
>>>
>>> Chandra Shekar B
>>>
>>>  
>>>
>>>
>>>
>>>  
>>>
>>> On Sat, Jun 18, 2011 at 12:05 AM, Daniel  wrote:***
>>> *
>>>
>>> Hi,
>>>
>>>  
>>>
>>> I don’t think there are tool to automate the processbecause the syntax is
>>> very similar. Can you post your code and tell which line produces the error
>>> ?
>>>
>>>  
>>>
>>> Regards.
>>>
>>> Daniel
>>>
>>>  
>>>
>>> *De :* excel-macros@googlegroups.com [mailto:e
>>> xcel-mac...@googlegroups.com] *De la part de* Chandra Shekar
>>> *Envoyé :* vendredi 17 juin 2011 10:13
>>> *À :* excel-macros@googlegroups.com
>>> *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code
>>>
>>>  
>>>
>>> Hi,
>>>
>>>  
>>>
>>> How to convert 2003 VBA code to 2007, because some of codes what I am
>>> running in 2003 is not running in 2007. Is there any way to convert this to
>>> any office to get the same result.
>>>
>>>  
>>>
>>> I am getting following error... Run-time error '-2147467259 (84005'):
>>> The specified dimension is not valid for the current chart type. 
>>>
>>> Thanks,
>>>
>>>  
>>>
>>> Chandra Shekar B
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><

Re: $$Excel-Macros$$ I want customised web query in excel

2011-06-22 Thread sharad jain

Thanks Ashish,

But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.

Also can you please let me know how create this type of macro?

Thanks,
Sharad

On Wed, Jun 22, 2011 at 7:18 PM, ashish koul  wrote:

> try this
>
>
> On Wed, Jun 22, 2011 at 5:59 PM, Ketan  wrote:
>
>>  Dear Members,
>>
>> ** **
>>
>> I have attached file which has macro to fetch data from NSE website 
>>
>> ** **
>>
>> In that I want that query to be customized like date range to change and
>> company name also changed 
>>
>> So that I can fetch data in excel by changing date range and symbol
>>
>> ** **
>>
>> Ketan Yadav
>>
>> ** **
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

2011-06-22 Thread Chandra Shekar

Thank u very much :)

On Wed, Jun 22, 2011 at 1:36 PM, ashish koul  wrote:

>
> http://www.bonavistasystems.com/Download2/MicroChartsTutorialBulletGraph.pdf
>
> http://www.exceluser.com/explore/bullet.htm
>
> http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html
>
> http://peltiertech.com/Excel/Charts/
>
>   On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
>> Please let me know which would be the best site to get required information.
>> I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am
>> not getting correct output.
>>
>> Thanks,
>>
>> Chandra Shekar B
>>
>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

2011-06-22 Thread Rajesh K R

Hi Vasant

Thanks for the code, its working well I need a condition in this the
columns must not be locked in case all the data entry cells filled eg;
 A  B C  D E  F  G H  I
S N NAME1   2   3   4   5   6   7
3   3   3   1   0   0   0   0
1   RAJESH  X   X   X   
2   SANUX   X   
3   ANILX   X   

Here in column C & D have full data so it have to be locked, but
column"E" don't have full data so it should remain unlocked till it
finished the data entry.Row 3 have counting formula & Cell "A3" have
the max formula. u can compare them for

Range("b2").Select
ActiveCell.Offset(0, 1).Select
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:="rajesh"
If ActiveCell.Text <> Range("a2").Text Then
ActiveCell.Offset(0, 1).Select
Else
ActiveCell.EntireColumn.Locked = True
ActiveSheet.Protect Password:="rajesh"
End If
Application.ScreenUpdating = True

The code explain my idea about locking, but I don't to know how to
make a loop .Pls consider this also & modify the code.

Regards
Rajesh Kainikkara   


On 6/22/11, Vasant  wrote:
> pls try this
>
> this will lock the populated cells in the range C3:AA5 in sheet 'april'
>
> Sub locksheet()
> Dim DataRng As Range, DataFilledRange As Range
> Dim WkSht As Worksheet
> Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:AA5")
> Set WkSht = ThisWorkbook.Worksheets("April")
> WkSht.Unprotect
> For Each cls In DataRng
> If cls.Value <> "" Then
> If DataFilledRange Is Nothing Then
> Set DataFilledRange = cls
> Else
> Set DataFilledRange = Application.Union(DataFilledRange, cls)
> End If
> End If
> Next cls
> With DataFilledRange
>   .Locked = True
>   .FormulaHidden = True
> End With
> WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> End Sub
>
> On Wed, Jun 22, 2011 at 3:54 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>>
>> I add a code in the work sheet for the identification of data
>> selected, But the copy paste is not working in that sheet. How can I
>> solve the issue,Pls check the code & tell me the change required.
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>> Application.EnableEvents = False
>> Columns(2).Interior.ColorIndex = 15
>> Cells(ActiveCell.Row, 2).Interior.Color = vbYellow
>> Application.EnableEvents = True
>> End Sub
>>
>> Regards
>> Rajesh Kainikkara
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
>
> Vasant
>
> --
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ I want customised web query in excel

2011-06-22 Thread ashish koul

try this

On Wed, Jun 22, 2011 at 5:59 PM, Ketan  wrote:

>  Dear Members,
>
> ** **
>
> I have attached file which has macro to fetch data from NSE website 
>
> ** **
>
> In that I want that query to be customized like date range to change and
> company name also changed 
>
> So that I can fetch data in excel by changing date range and symbol
>
> ** **
>
> Ketan Yadav
>
> ** **
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


refresh (1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

2011-06-22 Thread Vasant

pls try this

this will lock the populated cells in the range C3:AA5 in sheet 'april'

Sub locksheet()
Dim DataRng As Range, DataFilledRange As Range
Dim WkSht As Worksheet
Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:AA5")
Set WkSht = ThisWorkbook.Worksheets("April")
WkSht.Unprotect
For Each cls In DataRng
If cls.Value <> "" Then
If DataFilledRange Is Nothing Then
Set DataFilledRange = cls
Else
Set DataFilledRange = Application.Union(DataFilledRange, cls)
End If
End If
Next cls
With DataFilledRange
  .Locked = True
  .FormulaHidden = True
End With
WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

On Wed, Jun 22, 2011 at 3:54 PM, Rajesh K R wrote:

> Hi Experts
>
> I add a code in the work sheet for the identification of data
> selected, But the copy paste is not working in that sheet. How can I
> solve the issue,Pls check the code & tell me the change required.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Application.EnableEvents = False
> Columns(2).Interior.ColorIndex = 15
> Cells(ActiveCell.Row, 2).Interior.Color = vbYellow
> Application.EnableEvents = True
> End Sub
>
> Regards
> Rajesh Kainikkara
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ use ComboBox value to select range and then use range to create a chart

2011-06-22 Thread Jerry

Hi Ashish,

Thank you so much for the awesome help. I really appreciate it! The
workbook works fantastic!!!

I have a few questions

1,
Is it possible to use the values in D1: F1 (H3351, H3335, S3521) as
the series names when creating the chart? How to do so in the macro?

2
When I click the dark blue "CREATE" button, the macro executes and
creates the chart. How did you do that?

3
How to add a title to the chart, say "trend over time"?

Sorry for so many further questions, thank you so much for your time
and help again!!!

Jerry

On Jun 22, 1:25 am, ashish koul  wrote:
> check the attached workbook see if it helps
>
> On Wed, Jun 22, 2011 at 2:28 AM, Jerry (Zhao) Peng
> wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
>
> > I am trying to use VBA to achieve the following purpose:
>
> >    1. a UserForm pops up once I open a workbook, and the value on the
> >    drop-down list of 2 ComboBoxes on the UserForm will be automatically
> >    populated. (I have designed the UserForm, open VBE to view it in the
> >    attached file)
> >    2. on the UserForm, after I choose "starting year month" and "ending
> >    year month", and then click "Select Duration" CommandButton, the VBA code
> >    will select a range on sheet "data" and use the range as the source data 
> > to
> >    create a chart on sheet "data". For example,  if I select "2009 Jan" as
> >    "starting year month" and "2009 Apr" as "ending year month", 4 rows will 
> > be
> >    selected to be used as data range for the chart, see the area highlight 
> > in
> >    green. (the rudimentary VBA is also in the attached file)
>
> > My problem is I don't know how to use the values obtained from ComboBox
> > drop-down selection to set up the range. In my VBA code, there is a line to
> > select a fixed range, see below
>
> > *Set rngChtData = ActiveSheet.Range("c1:f49")*
>
> > If I know how to replace c1 with the address of the cell which contains the
> > value of "starting year month", and replace f49 with the address of the cell
> > that's 3 columns to the right of the cell which contains the value of
> > "ending year month", I will be getting very closer to my goal.
>
> > Any help is highly appreciated!
>
> > Thanks!
> > Jerry
>
> > --
>
> > --- 
> > ---
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.
>
>  ComboBox_chart(1).xls
> 77KViewDownload

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ solution to put data automtically

2011-06-22 Thread Subhash Yadav

No, this is daily entry sheet for fuel issued to equipments. This will
continue for years.


Regards,


Subhash Yadav

On Wed, Jun 22, 2011 at 6:16 AM, ashish koul  wrote:

> @ICWAI Help -  subhash  has already attached the file. please check the
> mail trail
>
> @subash - is there any fixed range where u will be adding the data if so
> then you can easily use vlookup or add any new col and start marking new
> values add with any text then you can use the lookp to get the  value
>
>
>
>
>
>
> On Tue, Jun 21, 2011 at 3:39 PM, ICWAI Help wrote:
>
>> HI Ashish ,
>>
>> could you please attached the sheet with below formula how it works.
>>
>> Thansk,
>> Rakesh.
>>
>> On Tue, Jun 21, 2011 at 8:35 AM, Subhash Yadav  wrote:
>>
>>> Thanks a lot my friend
>>>
>>>
>>>
>>> On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote:
>>>
 issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)

 reading  =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)


 On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav wrote:

> Dear friends,
>
> I am having one sheet containing data for fuel issue.
>
> I want, if i put any asset code previous issue and previous reading
> should come from the latest present issue and present reading of same 
> asset.
>
>
> In the attached sheet yellow cell date should come in yellow cell and
> magenta cell data should come in magenta cell.
>
> Please help me out.
>
>
> --
> Subhash Chand Yadav
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com 
 http://akoul.posterous.com/
 *akoul*.wordpress.com 
 My Linkedin Profile 


 P Before printing, think about the environment.


 --

 --
 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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> Subhash Chand Yadav
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> ht

$$Excel-Macros$$ How to learn VSTO with excel.

2011-06-22 Thread Mr excel

hi all,

  I want to learn VSTO for excel.anybody please give me the notes,pdf or
urls for learning.

thanks & regards...

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Private sub selection-change preventing copy paste

2011-06-22 Thread Rajesh K R

Hi Experts

I add a code in the work sheet for the identification of data
selected, But the copy paste is not working in that sheet. How can I
solve the issue,Pls check the code & tell me the change required.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Columns(2).Interior.ColorIndex = 15
Cells(ActiveCell.Row, 2).Interior.Color = vbYellow
Application.EnableEvents = True
End Sub

Regards
Rajesh Kainikkara

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-22 Thread ashish koul

Sub check()
If Application.Version = "12.0" Then


' code for 2007
   End If
   If Application.Version = "11.0" Then
   'code for 2003

End If
End Sub








On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Can we write different code do this. Where VBA code knows which version
> user is using according to that it changes chart plot area. If yes please
> let me know. Thanks!
>
> On Wed, Jun 22, 2011 at 12:34 AM, Daniel  wrote:
>
>>  Charts are quite different with Excel2007, so you have to resize the
>> plot area, change the series colors in order to get something similar. I use
>> Excel 2010 which is still different from Excel 2007.
>>
>> ** **
>>
>> Daniel
>>
>> ** **
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar
>> *Envoyé :* mardi 21 juin 2011 07:49
>>
>> *À :* excel-macros@googlegroups.com
>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
>>
>>   ** **
>>
>> Hi,
>>
>>  
>>
>> Graph output is different compare to 2003 and 2007. I have pasted both the
>> graphs in "Analysis Sheet". 2003 Ouput is that which is produced in 2003
>> which is perfect, but 2007 output which is pasted just below the data is
>> generated in 2007 which is not as 2003 output. 
>>
>>  
>>
>> Please run this code in both 2003 and 2007 you can find the difference.**
>> **
>>
>>  
>>
>> Thanks,
>>
>>  
>>
>> Chandra Shekar
>>
>> On Mon, Jun 20, 2011 at 11:46 PM, Daniel  wrote:
>>
>> Hi,
>>
>>  
>>
>> Can you ell which macro is involved and which result is different ?
>>
>>  
>>
>> Regards.
>>
>> Daniel
>>
>>  
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar
>> *Envoyé :* lundi 20 juin 2011 10:19 
>>
>>
>> *À :* excel-macros@googlegroups.com
>>
>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code 
>>
>>  
>>
>> Hi,
>>
>>  
>>
>> I am getting different output in 2003 & 2007 I gave pasted that in
>> attached workbook. Please let me know if you have any queries regarding
>> this. Thanks!
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>>  
>>
>>
>>
>>  
>>
>> On Sat, Jun 18, 2011 at 12:05 AM, Daniel  wrote:
>>
>> Hi,
>>
>>  
>>
>> I don’t think there are tool to automate the processbecause the syntax is
>> very similar. Can you post your code and tell which line produces the error
>> ?
>>
>>  
>>
>> Regards.
>>
>> Daniel
>>
>>  
>>
>> *De :* excel-macros@googlegroups.com [mailto:e
>> xcel-mac...@googlegroups.com] *De la part de* Chandra Shekar
>> *Envoyé :* vendredi 17 juin 2011 10:13
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code
>>
>>  
>>
>> Hi,
>>
>>  
>>
>> How to convert 2003 VBA code to 2007, because some of codes what I am
>> running in 2003 is not running in 2007. Is there any way to convert this to
>> any office to get the same result.
>>
>>  
>>
>> I am getting following error... Run-time error '-2147467259 (84005'):
>> The specified dimension is not valid for the current chart type. 
>>
>> Thanks,
>>
>>  
>>
>> Chandra Shekar B
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>  
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.co

Fwd: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

2011-06-22 Thread ashish koul

http://www.bonavistasystems.com/Download2/MicroChartsTutorialBulletGraph.pdf

http://www.exceluser.com/explore/bullet.htm
http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html

http://peltiertech.com/Excel/Charts/

  On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
> Please let me know which would be the best site to get required information.
> I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am
> not getting correct output.
>
> Thanks,
>
> Chandra Shekar B
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.





-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

2011-06-22 Thread ashish koul

http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html

http://peltiertech.com/Excel/Charts/

On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
> Please let me know which would be the best site to get required information.
> I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am
> not getting correct output.
>
> Thanks,
>
> Chandra Shekar B
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

2011-06-22 Thread Chandra Shekar

Hi,

I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
Please let me know which would be the best site to get required information.
I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am
not getting correct output.

Thanks,

Chandra Shekar B

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-22 Thread Chandra Shekar

Hi,

Can we write different code do this. Where VBA code knows which version user
is using according to that it changes chart plot area. If yes please let me
know. Thanks!

On Wed, Jun 22, 2011 at 12:34 AM, Daniel  wrote:

>  Charts are quite different with Excel2007, so you have to resize the plot
> area, change the series colors in order to get something similar. I use
> Excel 2010 which is still different from Excel 2007.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Chandra Shekar
> *Envoyé :* mardi 21 juin 2011 07:49
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
>
>   ** **
>
> Hi,
>
>  
>
> Graph output is different compare to 2003 and 2007. I have pasted both the
> graphs in "Analysis Sheet". 2003 Ouput is that which is produced in 2003
> which is perfect, but 2007 output which is pasted just below the data is
> generated in 2007 which is not as 2003 output. 
>
>  
>
> Please run this code in both 2003 and 2007 you can find the difference.***
> *
>
>  
>
> Thanks,
>
>  
>
> Chandra Shekar
>
> On Mon, Jun 20, 2011 at 11:46 PM, Daniel  wrote:
>
> Hi,
>
>  
>
> Can you ell which macro is involved and which result is different ?
>
>  
>
> Regards.
>
> Daniel
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Chandra Shekar
> *Envoyé :* lundi 20 juin 2011 10:19 
>
>
> *À :* excel-macros@googlegroups.com
>
> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code 
>
>  
>
> Hi,
>
>  
>
> I am getting different output in 2003 & 2007 I gave pasted that in attached
> workbook. Please let me know if you have any queries regarding this. Thanks!
> 
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
>  
>
>
>
>  
>
> On Sat, Jun 18, 2011 at 12:05 AM, Daniel  wrote:
>
> Hi,
>
>  
>
> I don’t think there are tool to automate the processbecause the syntax is
> very similar. Can you post your code and tell which line produces the error
> ?
>
>  
>
> Regards.
>
> Daniel
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Chandra Shekar
> *Envoyé :* vendredi 17 juin 2011 10:13
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code
>
>  
>
> Hi,
>
>  
>
> How to convert 2003 VBA code to 2007, because some of codes what I am
> running in 2003 is not running in 2007. Is there any way to convert this to
> any office to get the same result.
>
>  
>
> I am getting following error... Run-time error '-2147467259 (84005'):
> The specified dimension is not valid for the current chart type. 
>
> Thanks,
>
>  
>
> Chandra Shekar B
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>  
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.faceb

Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data

2011-06-22 Thread Chandra Shekar

Hi Ashish,

Thanks for the reply. Still user can edit and change text or assign a new
macro the textbox, but I want user not to edit text box and assign new macro
to it. Just he need to click on that to generate reports. Thanks!

On Tue, Jun 21, 2011 at 9:20 PM, ashish koul  wrote:

> Try this
> right click on image and chooze size and property the select don't move or
> size with cells
>
>
> [image: image.png]
>
>
> On Tue, Jun 21, 2011 at 5:02 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> In sheet1 how to protect shape("Click here to Generate Report") only. I
>> need complete access to graph and data.
>>
>> Thanks,
>>
>> Chandra Shekar
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>   --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

Re: $$Excel-Macros$$ I want customised web query in excel

$$Excel-Macros$$ Macro causing drawing objects to be deleted

$$Excel-Macros$$ Re: Dynamic Lookup Secrets is LIVE!

$$Excel-Macros$$ Re: Excel task

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Re: $$Excel-Macros$$ I want customised web query in excel

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Re: $$Excel-Macros$$ I want customised web query in excel

Re: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

Re: $$Excel-Macros$$ I want customised web query in excel

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

Re: $$Excel-Macros$$ use ComboBox value to select range and then use range to create a chart

Re: $$Excel-Macros$$ solution to put data automtically

$$Excel-Macros$$ How to learn VSTO with excel.

$$Excel-Macros$$ Private sub selection-change preventing copy paste

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Fwd: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

Re: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

$$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data

23 matches

Site Navigation

Mail list logo

Footer information