hiding the cell and the formula bar

[Guest]

Windows XP
Excel 2002 SP3

I've read through a number of entries on hiding cells via sheet protection
and hiding rows/columns.

I'm wondering if there is a way that I can put some entries into a
particular cell, and then make it so only the creator of the spreadsheet can
see whats in that cell. This is not like hiding the formula in a cell b/c in
my case there is no formula, so what shows up on the cell of page is what I
want to hide, not just the formula bar. Hiding rows/columns will not suffice.

Any suggestions?

Thanks,
Lou Sanderson

 

[Nick Hodge]

Lou

You can hide the value (or formula) in a cell from both he worksheet grid
and formula bar by Format>Cells...>Protection and checking hidden. Then
colour the font in those cells the same as the background (white) and
protect the sheet.

You could unlock the sheet and then view the data. Check printout first.

Alternatively, put all the sensitive data on a hidden sheet, hidden by

Worksheets("Sheet1").Visible = xlVeryHidden

This way the sheet cannot be unhidden from the UI...only code, just a couple
of ideas

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

Good idea nick, thanks!

Lou

You can hide the value (or formula) in a cell from both he worksheet grid
and formula bar by Format>Cells...>Protection and checking hidden. Then
colour the font in those cells the same as the background (white) and
protect the sheet.

You could unlock the sheet and then view the data. Check printout first.

Alternatively, put all the sensitive data on a hidden sheet, hidden by

Worksheets("Sheet1").Visible = xlVeryHidden

This way the sheet cannot be unhidden from the UI...only code, just a couple
of ideas

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk