PDA

View Full Version : Excel worksheets hidden??


vegyjones
27th January 2007, 00:53
I have a spreadsheet with 3 worksheets.

Worksheet number 3 contains information relevant to worksheet number 2.

Is there any way I can hide worksheet 3 before sending it to someone,
I want them to be able to edit worksheet 2, but not the info in worksheet 3!

Possible?
MattR
27th January 2007, 01:00
Not sure if that's possible but you could lock the sheet with a password.
GlosRFC
27th January 2007, 01:12
Format, Sheet, Hide
vegyjones
27th January 2007, 09:40
Not sure if that's possible .

You're no Glos or Mathare Matt :D

Cheers Glos
MattR
27th January 2007, 11:11
You're no Glos or Mathare Matt :D

Cheers Glos


No but it would still work :D
mathare
27th January 2007, 15:01
Someone could still unhide that sheet though unless you protect the workbook to prevent it
MattR
28th January 2007, 12:27
Someone could still unhide that sheet though unless you protect the workbook to prevent it


There you are Vegy, I was on the right lines :laugh