Can I hide sheet tabs so only some are accessible?
 

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.

Can I hide sheet tabs so only some are accessible?
 

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)

"Bchez" wrote:

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.

Can I hide sheet tabs so only some are accessible?
 

To hide them go to
format
sheet
hide

--
Greetings from New Zealand
"Sean Timmons" wrote in message
...
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)

"Bchez" wrote:

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.

Can I hide sheet tabs so only some are accessible?
 

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.
--
Greetings from New Zealand

"Bchez" wrote in message
...
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.