how to lock worksheet from myself!!

[iknowu99]

I am running a Macro and sometimes it accesses worksheets and looks up values - this is good. But sometimes it changes values in worksheets - no good

 

[SydneyGeek]

If it's changing values, that can only be because you told it to. Either you are writing new formulas, or copying and pasting in an unintended location. You could also be copying cells with formulas and pasting them in a different context. This will change the results of those calculations.

If you post your code, we can give you more specific guidance.

Denis

 

[iknowu99]

Hello Denis from Sydney, how's the weather over there?

This is the truth - it sometimes happens and I would like to know if there's a way for my code to be read only on some sheets. And the code is 40 pages long and top secret :P

 

[hsk]

Go to Tools -> Protection -> Allow Users to Edit Ranges

here u can specify cells which can be unlocked using password in a protected sheet

Then

Go to Tools -> Protection -> protect sheet
This locks all the cells in the given sheet,
only the cells u have specified previously can be unlocked using password !!

Probably this helps!

 

[Norie]

Your code is 'top secret'?

If it is then I don't see how we can help you.

As Denis pointed out the code will only do what you 'tell' it.

BTW 40 pages long?

Sounds like somethings not quite right.

 

[iknowu99]

hsk, you hit the spot

norie, if i reveal my code you will be the first one to see it

thanks guys