Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-06-2017, 03:36 AM
Sorin Sorin is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2017
Posts: 3
Sorin is on a distinguished road
Default time display


Hi,

Please give me an idea how to protect a excel file after a day deadline, even the user change the date of the system from Windows. Is it possible to extract the system date from BIOS?
Reply With Quote
  #2  
Old 01-06-2017, 03:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,605
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi
have you searched the Net yet?
Reply With Quote
  #3  
Old 01-06-2017, 05:28 AM
Sorin Sorin is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2017
Posts: 3
Sorin is on a distinguished road
Default

no, I don't know how and what to search
Reply With Quote
  #4  
Old 01-06-2017, 08:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,605
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Try " protect excel sheet after given date" or something along those lines
Reply With Quote
  #5  
Old 01-09-2017, 03:11 AM
Sorin Sorin is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2017
Posts: 3
Sorin is on a distinguished road
Default

what is happened when the user change the date of the system by given back the date?
Reply With Quote
  #6  
Old 01-09-2017, 04:06 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,605
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Probably using a macro. I'll move this to the programming section
Reply With Quote
  #7  
Old 01-10-2017, 10:28 AM
Logit Logit is offline Windows 10 Office 2007
Novice
 
Join Date: Jan 2017
Posts: 3
Logit is on a distinguished road
Default

You can create a small Text File that the program must "read" prior to opening for use. Place the text file in an obscure location in the computer system.

When the deadline date arrives, have your program delete that small text file. If the text file is not present when the program is run the next time - it fails to fully open for the user - just closes itself.

You can do the same thing with a REGISTRY entry.

You could also perhaps have the workbook delete itself upon expiration date.

Bottom line though, if someone wants to bypass your workbook security settings, they will manage to do so. Excel is not very secure.
Reply With Quote
Reply

Tags
date expired bios
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
No time display skaterbingo Outlook 0 11-30-2015 10:14 AM
Day date and time cell display markg2 Excel 2 02-11-2015 06:57 AM
Display txt in real-time Prostrelov Word 13 06-21-2014 08:48 AM
Display and Edit a Presentation at the same time. Techabca PowerPoint 3 05-02-2014 11:00 AM
Powerpoint : Display time elapsed on each slide Firee PowerPoint 1 11-27-2013 08:18 AM


All times are GMT -7. The time now is 01:35 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft