Re: $$Excel-Macros$$ VBA Macros classes

Hi, Thank you for the link, this will certainly help, but could you also suggest where I can take classroom training for Advanced VBA-Macros? Thanks Niraj On Sun, Aug 4, 2013 at 11:02 AM, xlstime wrote: > Hi Niraj, > > You can learn VBA online... try below link > > http://www.excel-pratique.c

$$Excel-Macros$$ Microsoft Excel 2010 Video Tutorials

develop your skills Microsoft Excel 2010 Video Tutorials - 2 DVD's Rs.250/ http://newdelhi.olx.in/microsoft-excel-2010-tutorials-2-dvd-s-rs-250-iid-528437465 prankk...@gamil.com -- 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 Face

$$Excel-Macros$$ Re: how to make a file expire after a period of time.

We can force the users to enable macros. 1. As 1st step code can be put up to enable macros else file would not open. 2. As 2nd step we can use macro to determine if the file has expired. This way the desired functionality can be achieved. Warm Regards, Anand Kumar On Saturday, 27 July 2013 14:2

Re: $$Excel-Macros$$ VBA Macros classes

Hi Niraj, You can learn VBA online... try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Sun, Aug 4, 2013 at 10:46 AM, Niraj Shirali wrote: > Hi, > > I'm new to this group and I'm hoping someone to help me guide. I'm from > Mumbai and am look

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Niraj . Enjoy Team XLS On Sun, Aug 4, 2013 at 10:56 AM, Niraj Shirali wrote: > Hello All, > > My name is Niraj Shirali, from Mumbai. Working with BNY Mellon. Looking > forward to learn VBA_macros in depth. Have developed some automations in > the past with some

$$Excel-Macros$$ Re: Introduce Yourself !!

Hello All, My name is Niraj Shirali, from Mumbai. Working with BNY Mellon. Looking forward to learn VBA_macros in depth. Have developed some automations in the past with some help and found this very interesting, however I tried learning through online and videos but not much satisfied so looki

$$Excel-Macros$$ VBA Macros classes

Hi, I'm new to this group and I'm hoping someone to help me guide. I'm from Mumbai and am looking to join a genuine classes to learn VBA-Macros (MS Excel) Foundation and Advanced. Please could anyone suggest, would be very grateful. Thank you Niraj Shirali -- Are you =EXP(E:RT) or =NOT(EXP(E

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Respected Suyog, Enabling macros functionality is provided to stop unwanted macros or virus running and corrupting the data.You can open the excel file and work on the contents.If you want the macro to run and the code be executed then one should enable macros.Expiry macro is a type of macro which

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Respected Vikas, Select the sheet and go to the format tab then protection tab of the dialiog box and remove the checkmarks for locked and hidden boxes.T hen select the cell for which that contain the formulas,then go gain to the format tab and recheck the locked and hidden boxes.Now,go to the rev

$$Excel-Macros$$ charting without data?

Hi all, I have had a request that I don't know if I can fulfill... I have been given pictures of graphs of varying styles and asked if I can recreate them. The issue is that I don't have the excel files with the data. Can this be done? Thanks in advance for any advise... Olivia -- Are you =EXP(

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Dear Vikas, Pl start new thread!! You will get response though. Thanks On Sat, Aug 3, 2013 at 8:05 PM, vikas tyagi wrote: > Hallo...experts. > How I can hide formulas to others in a sheet. > On Aug 3, 2013 2:24 PM, wrote: > >> ** >> Hi bosses >> >> Any assistance with this? Cheers >> Sent fr

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Hallo...experts. How I can hide formulas to others in a sheet. On Aug 3, 2013 2:24 PM, wrote: > ** > Hi bosses > > Any assistance with this? Cheers > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Hilary Lomotey > *Sender: * excel-macros@googleg

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Hi Kannan Interesting query. Would you share why you want an expiry on the file. Just trying to understand the circumstances under which one might want to add the funcitonality Cheers Umar On Mon, Jul 29, 2013 at 12:37 PM, Kannan Excel wrote: > how to make this??? > > can u send code??? > > an

Re: $$Excel-Macros$$ Double click event for different column HELP!!!

Hi Sajid, Try This If It Helps Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("c7:c200")) Is Nothing Then datacount = WorksheetFunction.CountA(Range("h:h")) Range("h" & 7 + datacount) = Target.Value End If If Not Intersect(Target, Range("l7:l20

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Hey Hillary Can you show an example of what you want in tustee sheet & also highligh the same with yellow color. Thanks On Fri, Aug 2, 2013 at 5:10 PM, Hilary Lomotey wrote: > Hello Experts, > > In the attached file, i have created two database, FIS and Equities > Database, and based on the d

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi , Most Welcome Sir. On Mon, Jul 29, 2013 at 10:27 AM, vba wrote: > Welcome back DP :) > > Its been pleasure having you. > > Cheers > On 29 Jul 2013 22:47, "De Premor" wrote: > >> just remember, that i also not yet introduce my self :( >> >> then let me introduce my self >> You can call me

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Hi bosses Any assistance with this? Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Fri, 2 Aug 2013 12:40:20 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Hello All, I've some questions on this. <> What if we set expiry date & time but "macros" are disabled on any PC ? whether that person can open this file ? <> Kindly review attached excel, I added similar code but while opening that file, excel first open that particular file & then ask me to e