Protection in Excel 2000 1

[venkman]

I posted this in the Microsoft Office forum, but I thought I would give a try here also:

In Excel XP you can protect a sheet, but allow certain ranges to be edited. Excel 2000 has protection, but does not seem to have this "allow users to edit ranges..." feature. Is there a work around? I'm sending out a survey to a bunch of people. The returned files will be processed by a macro and I'm trying to ensure tha people don't type in areas they are not supposed to. Unfortunately, I just found out that not everyone in the company is using Excel XP (although I am).

I was thinking I could write a macro which accomplishes this by using the built-in event system... but I think this would take me a while and I'm looking for an easier solution.
-Venkman

 

[Stretchwickster]

I asked a similar question a little while back, this post should is quite comprehensive and should answer your question:

thread707-522755

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[venkman]

Just to see if I got this straight from the other thread:

The feature is exactly the same in Excel 2000 as XP, but is not listed under the same menu. In Excel 2000, you must use format cells... protection tab...locked option. In Excel XP you can do this, or you can use the "allow users to edit ranges..." from the tools->protection menu.

Right?

-Venkman

 

[Stretchwickster]

From the sounds of it my answer is "yes". Although I must warn you that I have only used Excel 2000 and not Excel XP.

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[venkman]

Yeah, just confirmed that.

Thanks,
Venkman