Security Right

%3CLINGO-SUB%20id%3D%22lingo-sub-2288523%22%20slang%3D%22en-US%22%3ESecurity%20Right%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2288523%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20way%20to%20Secure%20my%20Rights%3F%3CBR%20%2F%3EI%20created%202%20sheets%20in%20excel%20for%20structural%20design%20and%20I%20want%20to%20make%20them%20work%20only%20for%20a%20limited%20duration%20after%20duration%20the%20inputs%20cases%20be%20not%20valid%20or%20become%20a%20blank%20sheet.%3CBR%20%2F%3EAny%20ideas%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2288523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2288659%22%20slang%3D%22en-US%22%3ERe%3A%20Security%20Right%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2288659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F866856%22%20target%3D%22_blank%22%3E%40safoine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20actually%20not%20intended%20to%20act%20as%20the%20password%20keeper%20of%20our%20files.%3C%2FP%3E%3CP%3EThe%20lock%20was%20originally%20used%20to%20protect%20areas%2C%20columns%2C%20lines%20or%20cells%2C%20so%20that%20data%20is%20not%20accidentally%20released%20when%20a%20file%20is%20edited%20together.%3C%2FP%3E%3CP%3EIn%20that%20time%20it%20was%20expanded%20much%20more%20than%20originally%20thought%2C%20especially%20with%20VBA%20you%20can%20do%20a%20lot%20in%20this%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20not%20one%20thing!%20...%20everything%20that%20can%20be%20locked%20with%20software%2C%20can%20also%20be%20unlocked%20with%20software.%20It's%20all%20a%20question%20of%20time%20and%20resources.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20there%20are%20ways%20to%20lock%20our%20Excel%20files%2C%20depending%20on%20what%20we%20want%20to%20do.%3C%2FP%3E%3CP%3EIn%20this%20case%2C%20I%20would%20recommend%20protecting%20the%20VBA%20Project%20with%20a%20password%20in%20advance.%3C%2FP%3E%3CP%3EThen%20I%20would%20write%20code%20with%20a%20time%20limit%20that%20is%20quick%20and%20easy.%3C%2FP%3E%3CP%3EYou%20can%20see%20an%20example%20in%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20course%20there%20are%20many%20other%20options%2C%20such%20as%20when%20the%20file%20is%20opened%2C%20an%20email%20should%20be%20sent.%3C%2FP%3E%3CP%3EIn%20the%20end%2C%20you%20always%20come%20across%20this%20small%20and%20elegant%20solution%20that%20I%20am%20sending%20you%20back.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Is there any way to Secure my Rights?
I created 2 sheets in excel for structural design and I want to make them work only for a limited duration after duration the inputs cases be not valid or become a blank sheet.
Any ideas please?

1 Reply

@safoine 

Excel is actually not intended to act as the password keeper of our files.

The lock was originally used to protect areas, columns, lines or cells, so that data is not accidentally released when a file is edited together.

In that time it was expanded much more than originally thought, especially with VBA you can do a lot in this direction.

 

But not one thing! ... everything that can be locked with software, can also be unlocked with software. It's all a question of time and resources.

 

Yes, there are ways to lock our Excel files, depending on what we want to do.

In this case, I would recommend protecting the VBA Project with a password in advance.

Then I would write code with a time limit that is quick and easy.

You can see an example in the attached file.

 

Of course there are many other options, such as when the file is opened, an email should be sent.

In the end, you always come across this small and elegant solution that I am sending you back.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.