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, we'll keep those sheets hidden as anyone can "unhide" those 
sheets.

If we can achieve this, that will be great. 

Regards,
Suyog

On Monday, 5 August 2013 11:41:55 UTC+5:30, pappu wrote:
>
> 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 required after a certain date
>
>
>
> On Sat, Aug 3, 2013 at 7:43 PM, Umar Abeer 
> <umar...@googlemail.com<javascript:>
> > wrote:
>
>> 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...@gmail.com<javascript:>
>> > wrote:
>>
>>> 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<javascript:>
>>> > wrote:
>>>
>>>> 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...@gmail.com <javascript:>> 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 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<javascript:>> 
>>>>>> wrote:
>>>>>>
>>>>>>    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"
>>>>>>>          ThisWorkbook.Close
>>>>>>>      End If
>>>>>>>
>>>>>>> End Sub
>>>>>>>
>>>>>>> Next step, you may add a cell validation on current file to avoid 
>>>>>>> skipped
>>>>>>> by user with changin the date on his computer
>>>>>>> Once the expiration msg appear, it will write in sheet1 cell A1 a 
>>>>>>> word
>>>>>>> EXPIRED, then everytime file open, it will check that cell and also 
>>>>>>> the
>>>>>>> date on current computer, if one of that criteria match then it will
>>>>>>> still close the workbook.
>>>>>>>
>>>>>>>      If Now() > Expired or *Sheet1**.Range(**"A1") = "EXPIRED"* Then
>>>>>>>          MsgBox "File " & ThisWorkbook.FullName & " expired"
>>>>>>>         *if Sheet1**.Range(**"A1") <> "EXPIRED" then
>>>>>>>          **   Sheet1.Range("A1") = "EXPIRED"**
>>>>>>> *           *ThisWorkbook.Save
>>>>>>>         End If
>>>>>>> *         ThisWorkbook.Close
>>>>>>>      End If
>>>>>>>
>>>>>>> Rgds,
>>>>>>> [dp]
>>>>>>>
>>>>>>>   Pada 27/07/2013 15:55, Kannan Excel menulis:
>>>>>>>
>>>>>>> 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<https://www.facebook.com/discussexcel>
>>>>>>>
>>>>>>> FORUM RULES
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>>>>>> Please
>>>>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>>>>>> Advice
>>>>>>> will not get quick attention or may not be answered.
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>> 5) Jobs posting is not allowed.
>>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>>
>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>>>>>>> and
>>>>>>> members are not responsible for any loss.
>>>>>>> ---
>>>>>>> You received this message because you are subscribed to the Google 
>>>>>>> Groups
>>>>>>> "MS EXCEL AND VBA MACROS" group.
>>>>>>> To unsubscribe from this group and stop receiving emails from it, 
>>>>>>> send an
>>>>>>> email to excel-macros...@**googlegroups.com <javascript:>.
>>>>>>> To post to this group, send email to 
>>>>>>> excel-...@googlegroups.com<javascript:>
>>>>>>> .
>>>>>>> Visit this group at 
>>>>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>>>>>> .
>>>>>>> For more options, visit 
>>>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>>>>> .
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>   --
>>>>>>> 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<https://www.facebook.com/discussexcel>
>>>>>>>
>>>>>>> FORUM RULES
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>>>>>> Please
>>>>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>>>>>> Advice
>>>>>>> will not get quick attention or may not be answered.
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>> 5) Jobs posting is not allowed.
>>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>>
>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>>>>>>> and
>>>>>>> members are not responsible for any loss.
>>>>>>> ---
>>>>>>> You received this message because you are subscribed to the Google 
>>>>>>> Groups
>>>>>>> "MS EXCEL AND VBA MACROS" group.
>>>>>>> To unsubscribe from this group and stop receiving emails from it, 
>>>>>>> send an
>>>>>>> email to excel-macros...@**googlegroups.com <javascript:>.
>>>>>>> To post to this group, send email to 
>>>>>>> excel-...@googlegroups.com<javascript:>
>>>>>>> .
>>>>>>> Visit this group at 
>>>>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>>>>>> .
>>>>>>> For more options, visit 
>>>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>>>>> .
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>  --
>>>>>> 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<https://www.facebook.com/discussexcel>
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>>>>> Please
>>>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>>>>> Advice will
>>>>>> not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE  : Don't ever post confidential data in a workbook. Forum owners 
>>>>>> and
>>>>>> members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google 
>>>>>> Groups
>>>>>> "MS EXCEL AND VBA MACROS" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it, 
>>>>>> send an
>>>>>> email to excel-macros...@**googlegroups.com <javascript:>.
>>>>>> To post to this group, send email to 
>>>>>> excel-...@googlegroups.com<javascript:>
>>>>>> .
>>>>>> Visit this group at 
>>>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>>>>> .
>>>>>> For more options, visit 
>>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>>>> .
>>>>>>
>>>>>>
>>>>>>
>>>>>>  
>>>>>  
>>>> -- 
>>>> 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<https://www.facebook.com/discussexcel>
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security 
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE  : Don't ever post confidential data in a workbook. Forum owners 
>>>> and members are not responsible for any loss.
>>>> --- You received this message because you are subscribed to the Google 
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send 
>>>> an email to excel-macros...@**googlegroups.com <javascript:>.
>>>> To post to this group, send email to 
>>>> excel-...@googlegroups.com<javascript:>
>>>> .
>>>> Visit this group at 
>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>>> .
>>>> For more options, visit 
>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>> .
>>>>
>>>>
>>>>
>>>  -- 
>>> 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 thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>  
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>>> members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to excel-macros...@googlegroups.com <javascript:>.
>>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>>> .
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>  
>>>  
>>>
>>
>>  -- 
>> 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 thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com <javascript:>.
>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to