Re: $$Excel-Macros$$ Hide & lock a formula in the cell

2017-05-07 Thread Puneet Jain
Dear Mr. Paul Thanks for the response. Need one more help. I have 2 worksheet in one file and both are linked to each other. I did the same as explained by you and was successful. Now for the second worksheet, if i need to lock only one coloum and unlock the second coloum, is it possible? E

Re: $$Excel-Macros$$ automation for advanced filter

2017-05-07 Thread 'Minta Spriggs' via MS EXCEL AND VBA MACROS
On Sun, 5/7/17, 'Regine Silvers' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ automation for advanced filter To: excel-macros@googlegroups.com Date: Sunday, May 7, 2017, 12:19 PM ---

Re: $$Excel-Macros$$ automation for advanced filter

2017-05-07 Thread 'Regine Silvers' via MS EXCEL AND VBA MACROS
On Sun, 5/7/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ automation for advanced filter To: excel-macros@googlegroups.com Date: Sunday, May 7, 2017, 9:09 AM

Re: $$Excel-Macros$$ automation for advanced filter

2017-05-07 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS
On Sat, 5/6/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ automation for advanced filter To: "MS EXCEL AND VBA MACROS" Date: Saturday, May 6, 2017, 2:38 PM That's really great and thanks a ton -- Are you =EXP(E:RT) or =NOT(EXP(E: