hiding the cell and the formula bar
 

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

hiding the cell and the formula bar
 

Lou

You can hide the value (or formula) in a cell from both he worksheet grid
and formula bar by FormatCells...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

HIS
www.nickhodge.co.uk

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

hiding the cell and the formula bar
 

Good idea nick, thanks!

"Nick Hodge" wrote:

Lou

You can hide the value (or formula) in a cell from both he worksheet grid
and formula bar by FormatCells...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

HIS
www.nickhodge.co.uk

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