Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Carl
 
Posts: n/a
Default lock spreadsheet by date

Is there a way that I can password protect a workbook so that it will lock
all within a set time frame?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Not with any real assurance.

Almost anything I would do would rely on macros and macros can be disabled.

Carl wrote:

Is there a way that I can password protect a workbook so that it will lock
all within a set time frame?


--

Dave Peterson
  #3   Report Post  
Carl
 
Posts: n/a
Default

Do you have any suggestions on how I could do something of a similar natire?

"Dave Peterson" wrote:

Not with any real assurance.

Almost anything I would do would rely on macros and macros can be disabled.

Carl wrote:

Is there a way that I can password protect a workbook so that it will lock
all within a set time frame?


--

Dave Peterson

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Nothing that would actually work in all cases.

You could add a routine that would lock the sheets if after a certain date. But
that protection is easily broken.

Carl wrote:

Do you have any suggestions on how I could do something of a similar natire?

"Dave Peterson" wrote:

Not with any real assurance.

Almost anything I would do would rely on macros and macros can be disabled.

Carl wrote:

Is there a way that I can password protect a workbook so that it will lock
all within a set time frame?


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet End Date mjh Excel Discussion (Misc queries) 1 January 23rd 05 10:36 AM
Detecting Oldest Date On Spreadsheet Keiron James Keeble Excel Discussion (Misc queries) 3 January 19th 05 01:09 AM
Lock in current date Angus Excel Discussion (Misc queries) 1 January 12th 05 05:27 PM
How do I add a date field in a spreadsheet? Minimidge Excel Worksheet Functions 2 January 6th 05 04:57 PM
Date format in spreadsheet tandem Excel Worksheet Functions 10 December 9th 04 07:19 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"