Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

locking cell with password

0

Dears,

I have an evaluting sheet consists of 10 points. Also I have 5 people that they

have to put there evalute these points. each point Ihave given it a specfic weight.

Since the Excel evaluating sheet is commen between all. I want to lock each coulmn

with a specific password that will hide the content of the cells in that coulmn. So that, any one who is going to put his evaluation will not get affected by others which they have evalute it earlier.

OR

if you have any other Idea, it welcome.

thanks

excel
posted by: Aaa_111 (rep: 2) on Tue Oct 31, 2017 at 5:54 am
Answer
Discuss

Discussion

Give each of the participants his or her own workbook. Arrange it so that their evaluations are in a single column. When they give back their workbooks to you copy that one column to different column of a master where you have all five replies in five columns side by side.
Variatus (rep: 4889) Oct 31, '17 at 7:00 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login