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

Hello All, I've reviewed all replies. Can we do following things ? <> After opening excel, Sheet1 only should get open ! <> On sheet1, we can write that "Without Enabling macro facility" this excel will not work. <> Can we prepare macro which will keep all "fonts & cells" in white color ? <> I

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

Hi Umar Abeer, Its very simple if ur company want to terminate u, then u can use this macro in master data :-) am just joking... I thought this would be a great security feature for an annual subscription feature I have on my site. Ideally the spreadsheet would lock or a password would be re

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$$ 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$$ 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

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

This is the sample code, you can set it up in ExpDate variable Private Sub Workbook_Open() Dim ExpDate As Date ExpDate = #8/17/2013 10:00:00 AM# If Now > ExpDate Then ThisWorkbook.Close MsgBox "This workbook will expired at " & Format(ExpDate, "dd hh:mm:ss AM/PM") End

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

thanks thanks a lot i am really happy. On Mon, Jul 29, 2013 at 2:13 PM, De Premor wrote: > sorry little mistake there, try new attached > > > On 29/07/2013 15:37, Kannan Excel wrote: > > how to make this??? > > can u send code??? > > and if i type user and pswd means, permissio

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

can u do me a favor??? i don't want user and pswd... i want vb coding for expire date and time pls send that code how to set date and time to expire On Mon, Jul 29, 2013 at 1:16 PM, De Premor wrote: > try this attached file > > user, pass, and expiration date defined in a sheet > > > On 29/0

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

how to make this??? can u send code??? and if i type user and pswd means, permission granted or user has expired message only appear... excel sheet not open... On Mon, Jul 29, 2013 at 1:16 PM, De Premor wrote: > try this attached file > > user, pass, and expiration date defined in a sheet

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

try this attached file user, pass, and expiration date defined in a sheet On 29/07/2013 13:05, Mangesh Vimay wrote: Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel wrote: Hi, I want to set

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

Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel wrote: > Hi, > > I want to set particular date and* time* also for expire is this > possible.??? > > Or i want to set date and time for passw

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

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 wrote: > Using ma

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

What you want to do after expiration. .? On 27 Jul 2013 14:25, "Kannan Excel" wrote: > Hi, > > how to make a file expire after a period of time. > > > regards > Kannan V > > -- > 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 Facebo

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

Using macro, but required user to run the macro This is the basic, user still can skip this by changing date on his computer Private Sub Workbook_Open() Dim Expired As Date Expired = "20 Jul 2013" If Now() > Expired Then MsgBox "File " & ThisWorkbook.FullName & " expired"

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

Wow great Querry!!! Even I am excited to know it. Johnson On Sat, Jul 27, 2013 at 2:25 PM, Kannan Excel wrote: > Hi, > > how to make a file expire after a period of time. > > > regards > Kannan V > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N

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

Hi, how to make a file expire after a period of time. regards Kannan V -- 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 t