$$Excel-Macros$$ Re: macro for hard copy of formulas

2015-12-30 Thread GENIUS
IT IS WORKING THANK YOU VERY MUCH FOR YOUR HELP > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ formatting cell

2015-12-30 Thread Abhishek Jain
You can use below formula in B1 and set desired format. Then copy B1 and select rest of the cells where you want the formatting and use Paste Special > Formats. *=AND(A1<>"",A1<=TODAY()-15)* On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde wrote: > Dear all > One small query. > I have a dat

$$Excel-Macros$$ formatting cell

2015-12-30 Thread Shrinivas Shevde
Dear all One small query. I have a date in Cell a1 I want to format a cell b1, such that whenver the 15 days over the cell b1 should fill with any colour. Eg A1 has 10th jan 2015 then cell b1 should fill with any colour on 26th jan 2015 Is it possible if yes please let me know how to do the same.

$$Excel-Macros$$ Extract reports into a new workbook

2015-12-30 Thread Rajeev Kumar
Dear Experts, Please find attached excel file and help accordingly. I have explained my requirement in sheet1 Thanks / Regards, -- Rajeev Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ http

Fwd: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-30 Thread Pankaj Sharma
Hi Rajeev, You can also use this Form too. ☺ user1 USER PASSWORD user2 GUEST *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* -- Forwarded message

Fwd: $$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

2015-12-30 Thread Devendra Sahay
Hi Experts, I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or =NOT

$$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

2015-12-30 Thread Devendra Sahay
Hi Experts, I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or =NOT

Re: $$Excel-Macros$$ Enable/Disable text box based on User Login

2015-12-30 Thread Rajeev Kumar
Dear Abhishek, Please note that the Text boxes should be visible but it should be inactive when Guest Login. during login window worksheet should not visible in background. is it possible? On Wed, Dec 30, 2015 at 11:32 AM, Rajeev Kumar wrote: > Please find attached example file and help on it. >

Re: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-30 Thread Rajeev Kumar
Thanks a lot Cheers On Wed, Dec 30, 2015 at 11:33 AM, Abhishek Jain wrote: > Dear Rajeev, > > Please see attached. > > User 1 - > > ADMIN > admin123 > > User 2 > GUEST > guest123 > > *Both user names and passwords are case-sensitive.* > > HTH, Abhishek > > On Wed, Dec 30, 2015 at 1:11 PM, Rajee

Re: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-30 Thread Abhishek Jain
Dear Rajeev, Please see attached. User 1 - ADMIN admin123 User 2 GUEST guest123 *Both user names and passwords are case-sensitive.* HTH, Abhishek On Wed, Dec 30, 2015 at 1:11 PM, Rajeev Kumar wrote: > Please find attached file and help as per requirement. > > Thanks in advance > > On Wed,

Re: $$Excel-Macros$$ Enable/Disable text box based on User Login

2015-12-30 Thread Rajeev Kumar
Please find attached example file and help on it. Thanks in advance On Wed, Dec 30, 2015 at 9:27 AM, Abhishek Jain wrote: > Please share sample of your worksheet and mention what textboxes you want > to be disabled in Guest mode. > > Rgds, Abhishek > > > On Wed, Dec 30, 2015 at 11:08 AM, Rajeev