Re: $$Excel-Macros$$ Required editable maps in Excel

2013-07-07 Thread ashish koul
visit these links http://www.clearlyandsimply.com/clearly_and_simply/choropleth-maps/ http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html http://www.clearlyandsimply.com/clearly_and_simply/2009/06/multicolored-choropleth-maps-with-excel.html Regards Ashish

$$Excel-Macros$$ Is it possible to hide the name manager menu?

2013-07-07 Thread Aashish Watve
Hi, I am working on a excel dashboard, where I have hidden many worksheets. However, the name manager shows the formulas I have used referring to the hidden worksheets. I am however not able to find a way to hide the formula's, cell references, lists I have used in various formulas. They appear

Re: $$Excel-Macros$$ Is it possible to hide the name manager menu?

2013-07-07 Thread Sam Mathai Chacko
Aashish, Even if you hide the name manager button, one could still envoke it using CTRL + F3. Regards, Sam On Sun, Jul 7, 2013 at 5:50 PM, Aashish Watve aashi...@gmail.com wrote: Hi, I am working on a excel dashboard, where I have hidden many worksheets. However, the name manager shows

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

2013-07-07 Thread Mangesh Vimay
Thank you very much !!! On 7/7/13, vba v...@vabs.in wrote: Hi PFA... Reason for error: cell was referring to NA. Make sure cell is referred correctly. Thanks On Sun, Jul 7, 2013 at 10:04 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi, When I am trying to run the macro, I am

Re: $$Excel-Macros$$ Validation through Macro!!!

2013-07-07 Thread Indrajit $nai
Thanks a lot for your help. Sure it will help me a lot, but if I stuck somewhere then definitely I'll get back to you. On Sat, Jul 6, 2013 at 5:54 PM, vba v...@vabs.in wrote: Hi Indrajit, You have asked something diff.. PFA sheet where i have set restrictions for few cases.. I hope you

$$Excel-Macros$$ Re: Is it possible to hide the name manager menu?

2013-07-07 Thread Prince
Do you want to hide formulas in the cells ? if yes then just lock the cells and protact the sheet. Please Correct if i m wrong. regards Prince On Sunday, July 7, 2013 5:50:24 PM UTC+5:30, Aashish Watve wrote: Hi, I am working on a excel dashboard, where I have hidden many worksheets.