Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|