Restricting the usage of sheet

[Kiran Mambi]

I am looking out for code for locking a sheet but the code
placed in the different sheet, may be sheet2 and should be effective
in the sheet named Demo. The reason being there are many imp
formulas at various locations in Demo sheet.
In sheet named Demo I want to set the locking based on the number
set in cell C8. C8 does not have any formula.
Say I start the number from 1001 in cell C8.
The starting number can be any number. This is just an example.
I want three options in the code.

1) From some number x started in C8 the sheet should stop working
when the code reaches to x+7000
2)It starts prompting a message like
YOUR SHEET IS ABOUT TO EXPIRE. CONTACT SYSTEM DEPT.
when the number reaches x+6500
3)Also when it reaches x+7000 and I want to allow to continue further
more 7000 then I can do that i.e in C8 it will continue from 8001.

The third option is just a thought. If not possible then in the code somewhere
I can mention the same number that I mention in C8 and it continues further
more. Or pressing some set of ctrl+keys it resets the counter for further 7000
and continues which only I am aware of.

Thanks
Kiran

[patel45]

1) From some number x started in C8 the sheet should stop working
when the code reaches to x+7000

it's not clear for me, what code ? need a sample file

[HaHoBe]

Hi, Kiran Mambi,

I am looking out for code for locking a sheet but the code placed in the different sheet, may be sheet2 and should be effective in the sheet named Demo.

AFAIK itīs not possible.

Say I start the number from 1001 in cell C8.

You should consider using a hidden sheet, a custom builtindocumentproperty, a name, a text file for saving the value.

Excel is not a safe application when it comes to protecting your code, no matter what you try. You would need to incorporate a third party tool or use VB/VS to program.

Ciao,
Holger

[Kiran Mambi]

Hello
patel45 & HaHoBe

x is just any number from where I want the code to start counting.
what is the third party tool or use VB/VS to program and does it help in solving the problem.

thanks
Kiran

[HaHoBe]

Hi, Kiran Mambi,

Third party Tools are helpers which try to overcome the poor safety of Excel by encrypting the contents and just allow them to be opened with that software/password/keys.

Visual Studio and Visual Basic are programming languages which will allow applications to run without a host as is the normal behaviour of VBA.

I doubt that sharing the workbook will not really work with either of these programs to well. For me the best way to overvcome this is to use a RDBS for this kind of work and Excel only being the frontend if needed.

Ciao,
Holger

[Kiran Mambi]

For the time being if I compromise and try for the first point
(i.e the sheet gets blocked after the counter reaches x+7000)
and to be used in the same Demo sheet then is it possible.
Also if you can suggest me some better option.

Thanks
Kiran