Re: $$Excel-Macros$$ Expire date

Sub ExpDate() Tdate = DateSerial(2013, 1, 24) If Tdate >= Format(Now(), "dd/mm/") Then RunMacro Else MsgBox "Program Expired", vbCritical, "Program Status" ThisWorkbook.Save ThisWorkbook.Close End If End Sub On Tue, Feb 12, 2013 at 7:20 AM, NRao Myn

$$Excel-Macros$$ Expire date

Hi Team, I develop a tool in excel using with macro but i am not able to added expire date in that. Please help on this. Thanks Narasimha -- 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://ww

Re: $$Excel-Macros$$ VBA for Hide & Unhide specific bunch of sheets

Hi Amar Please see attached file. I used check boxes to Hide/Unhide sheets. On Mon, Feb 11, 2013 at 12:54 PM, amar takale wrote: > Dear All, > Pls suggest VBA Code I attached detailed in sheet > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

Hi Ashish, Yes there will be more than one chart or max two i want to add these chart in the main sheet. Would you please suggest me the code. Thanks a ton !!! On Mon, Feb 11, 2013 at 8:37 PM, ashish koul wrote: > will thr be more than one chart in source workbook. If so what would u > like t

Re: $$Excel-Macros$$ Macro

*buy book * *excel power programming by john walkenbach and study it* * * also visit http://www.staff.city.ac.uk/~fring/ExcelVBA/ * * * * * * On Mon, Feb 11, 2013 at 1:00 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Expert, > > > > I wanna learn basic macro, please a

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

will thr be more than one chart in source workbook. If so what would u like to do , On Mon, Feb 11, 2013 at 2:04 PM, Mangesh Vimay wrote: > Friends, > > Please help me to get this issue resolved. > > Thanks in advance !!! > > On 2/10/13, Mangesh Vimay wrote: > > Hi Friends, > > > > I need vba c

Re: $$Excel-Macros$$ VBA for Hide & Unhide specific bunch of sheets *

Dear Hilary, Thank for solution but problem is that I need exact opposite code to hide specific sheets bcos unhide sheets more than 20,then it is time consumable to put sheet name in code.So If code is opposite which you send then it is possible for me bcos hide sheets only 4 sheets. Also unhide s

Re: $$Excel-Macros$$ VBA for Hide & Unhide specific bunch of sheets *

change the sheet name as per ur requirement Sub Hide() ' 'Hide all worksheets except the list below For i = 1 To ActiveWorkbook.Sheets.Count If Sheets(i).Name = "Dashboard1" Or Sheets(i).Name = "Dashboard2" Or Sheets(i).Name = "Dashboard3" Or Sheets(i).Name = "Dashboard4" Or Sheets(i).Name =

$$Excel-Macros$$ VBA for Hide & Unhide specific bunch of sheets

Dear All, Pls suggest VBA Code I attached detailed in sheet Regards Amar -- 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 th

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay wrote: > Hi Friends, > > I need vba code to insert a chart from another Excel file. > > I have attached sample sheet. Please do the needful. > > Thanks !!! > > -- > With regards, > > *MaNgEsH* >