$$Excel-Macros$$ Re: Query

2015-07-09 Thread Rohit Jadhav
Hi Soumyendu Paul I'm not exactly sure what you want. So here's my understanding "If user makes any changes in the file he/she has to click the Send mail button before closing the file and you have code for sending the mail " A simple way is to use activex control button instead of the shape you

$$Excel-Macros$$ Please Point error in following UDF

2015-07-09 Thread Rohit Jadhav
Hi I had made this UDF based on the needs of a question asked in this forum. However when i change anything in VBA code (as minute as adding comments or add a point to debug etc. ) the calculated value becomes zero on the worksheet. Also the function does not update automatically when input data

$$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread Rohit Jadhav
Hi I want to sort a range say a1 to j15 containing various details of one's mutual fund portfolio like company name, fund name, fund type, no of units held, NAV , dividend received etc. I have created sorting code from excel but is it possible to reduce this code. I am using a separate function

$$Excel-Macros$$ Help for error :Excel help viewer has encountered a problem & cannot continue.

2015-06-11 Thread Rohit Jadhav
Hi I'm not able to access any help from Excel 2007. I have attached the error snap shot here. I tried reinstalling Excel but after sometime it comes back. I also downloaded latest updates from MS site but it did not make any difference. Has any one faced & solved this problem successfully. Als

$$Excel-Macros$$ Re: Please help with Activex "cannot insert object". error

2015-04-26 Thread Rohit Jadhav
The Appdata folder in itself is hidden. So you can see that i have already unhidden the files from the folder options view tab. Any ways thanks for the reply. On Thursday, April 23, 2015 at 1:28:05 PM UTC+5:30, Rohit Jadhav wrote: > > Hi > I have been experiencing this error recently

$$Excel-Macros$$ Re: Please help with Activex "cannot insert object". error

2015-04-23 Thread Rohit Jadhav
Microsoft site but the problem still persists. So now I'm don't know what is wrong. On Thursday, April 23, 2015 at 1:28:05 PM UTC+5:30, Rohit Jadhav wrote: > > Hi > I have been experiencing this error recently in Excel 2007. Whenever try > to add any ACTIVEX buttons to my wo

$$Excel-Macros$$ Re: How to declare public array

2015-03-25 Thread Rohit Jadhav
Thanks a lot. It definitely solves my problem. Can you please tell me how to declare array using public keyword. On Wednesday, March 25, 2015 at 4:10:48 PM UTC+5:30, Rohit Jadhav wrote: > > > Hi > I have a simple question > I'm trying to declare a public array myarray which c

$$Excel-Macros$$ How to declare public array

2015-03-25 Thread Rohit Jadhav
attached files -- With Regards, Rohit Jadhav. -- 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 thread title

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 4 updates in 3 topics

2015-03-25 Thread Rohit Jadhav
gest&utm_medium=email> > Back to top <#14c48feab238800e_digest_top> >You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest

$$Excel-Macros$$ Re: need macro

2014-07-29 Thread Rohit Jadhav
Hi Vibhav, The password "password" is not working. When I enter it first time, I get a window asking for write password. Whether you enter "password" or click read only the file automatically closes. I have set macro security to "enable all macros" mode. Can you tell me what I'm doing wrong here

$$Excel-Macros$$ Re: need macro

2014-07-28 Thread Rohit Jadhav
Hi Vaibhav I want to see the code can you please provide the password for the file. On Thursday, July 24, 2014 4:05:55 PM UTC+5:30, SUDHIR VERMA wrote: > > Dear Experts, > > I need macro, which can encrypt with password after defined no of days. > > Example- i make file today, after