Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-28 Thread xlstime
and what about formula . Enjoy Team XLS On Sun, Jul 28, 2013 at 11:10 AM, De Premor d...@premor.net wrote: using udf On Cell A3, type* =Eval(A2)* then, on VBE, add module and paste this code *Function eval(str As String)** **eval = Evaluate(str)** **End

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-28 Thread De Premor
create defined name inexample : *Eval**A2* that referring to =EVALUATE(A2) Then in some cell in that sheet, just type *=EvalA2** * Pada 28/07/2013 14:59, xlstime menulis: and what about formula . Enjoy Team XLS On Sun, Jul 28, 2013 at 11:10 AM, De Premor

$$Excel-Macros$$ Linking Pages from PPT Slide to Excel Sheet Back to that PPT Slide

2013-07-28 Thread Amit Desai (MERU)
Dear Friends, I am trying to prepare a Presentation wants to link one sheet of an excel file. Once done I want a reverse link to that slide. I am able to link the files but not to particular sheet slide... Please Assist. Best Regards, Amit Desai

RE: $$Excel-Macros$$ Linking Pages from PPT Slide to Excel Sheet Back to that PPT Slide

2013-07-28 Thread Amit Desai (MERU)
Dear De Premor, Thanks a lot.. Best Regards, Amit Desai Mobile:- +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: 28 July 2013 16:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Linking Pages from PPT

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

2013-07-28 Thread Kannan Excel
Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date and time for password... When i set date and time, password will appear automatically pls do the needful ASAP... On Sat, Jul 27, 2013 at 3:19 PM, De Premor d...@premor.net