Can I hide sheet tabs so only some are accessible?

  • Thread starter Thread starter Bchez
  • Start date Start date
B

Bchez

I train employees and make tests in Excel. Each person's test answer sheet
is on a sheet tab. How can I hide all the tabs except for the one student I
am sending it to? I don't want students to see other student's answers.
 
Hide the desired sheets, then go to Tools > Protection > Protect workbook and
put a password on it.

But, please be aware, Excel security can be bypassed.

If you have concerns that someone will attempt a workaround, consider
right-clicking on the tab or tabs desired and selecting Move or Copy and
click Create a copy, then send to each student. Then, they;ll only have their
own sheet(s)
 
Or you send them all a workbok with just the one sheet.
It's easy to copy a sheet.
just right click onto the tab and select move or copy
etc you need to tick "create a copy"
and select " new book" You could name each book with the pupils name and
later collate them back again.
 
Back
Top