$$Excel-Macros$$ Re: Query

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

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

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

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.

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.

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

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 in Excel

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

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 worksheet I get an error cannot

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

and stop receiving emails from it send an email to excel-macros+unsubscr...@googlegroups.com. -- 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

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

-- 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 titles, like Please

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

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 can be used by either

$$Excel-Macros$$ Re: need macro

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. If

$$Excel-Macros$$ Re: need macro

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 20