ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lock spreadsheet by date (https://www.excelbanter.com/excel-discussion-misc-queries/18850-lock-spreadsheet-date.html)

Carl

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?

Dave Peterson

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

Carl

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

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


All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com