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

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.

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

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 wrote: > Hi Indrajit, > > You have asked something diff.. > > PFA sheet where i have set restrictions for few cases.. I hope you can > mana

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

Thank you very much !!! On 7/7/13, vba 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 > wrote: > >> Hi, >> >> When I am trying to run the macro, I am getting the err

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

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 wrote: > Hi, > > I am working on a excel dashboard, where I have hidden many worksheets. > However, the name manager shows the formulas I ha

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

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 i