hiding the cell and the formula bar


G

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
 
Ad

Advertisements

N

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
 
Ad

Advertisements

G

Guest

Good idea nick, thanks!

Nick Hodge said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top