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: $$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 can't say,

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 enable

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 kannan.ex...@gmail.comwrote: how to make this??? can u

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

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 kannan.ex...@gmail.com wrote: Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date

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 kannan.ex...@gmail.com

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 d...@premor.net wrote: try this attached file user, pass, and expiration date

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 d...@premor.net 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.

thanks thanks a lot i am really happy. On Mon, Jul 29, 2013 at 2:13 PM, De Premor d...@premor.net 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,

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 d...@premor.net

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

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 kannan.ex...@gmail.comwrote: 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

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.

What you want to do after expiration. .? On 27 Jul 2013 14:25, Kannan Excel kannan.ex...@gmail.com 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