|
Hide Names
Hi,
I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much. |
Hide Names
excel 2003
one way might be to set your own password for file opening if not matched the Workbook_Open event would delete the Formula toolbar Private Sub Workbook_Open() Application.DisplayFormulaBar = True k = InputBox("Insert a password") If k < "your_password" Then Application.DisplayFormulaBar = False End Sub pls click YES if it helped On 6 Lis, 12:16, Stanley wrote: Hi, I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much. |
Hide Names
Private Sub Workbook_Open()
Application.DisplayFormulaBar = True If InputBox("Insert a password") < "your_password" Then Application.DisplayFormulaBar = False End Sub is even simpler On 6 Lis, 12:37, Jarek Kujawa wrote: excel 2003 one way might be to set your own password for file opening if not matched the Workbook_Open event would delete the Formula toolbar Private Sub Workbook_Open() Application.DisplayFormulaBar = True k = InputBox("Insert a password") If k < "your_password" Then Application.DisplayFormulaBar = False End Sub pls click YES if it helped On 6 Lis, 12:16, Stanley wrote: Hi, I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much.- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
Hide Names
Just select the cells for which you have applied the formula and do right
clickFormat CellsProtectionTick Both Locked & Hidden Check boxes and give ok. Unlock all the cells which ever you want the people to have access as mentioned below: Select the Columns Or Cells that needs to have the Editing option and do right clickFormat CellsProtectionUncheck Both the Locked & Hidden Check boxes and give ok. Now Protect the worksheet with a password. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Stanley" wrote: Hi, I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much. |
Hide Names
Jan Karel Pieterse (http://jkp-ads.com) has developed a custom Name
Manager that gives you much more control over names than Excel's built-in name manager. It allows you to hide names from appearing in the Name Box or in Excel's Name Manager. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Stanley wrote: Hi, I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much. |
Hide Names
Thanks for the reply.
This doesnt stop the Name Box being on the screen with the drop-down list of all names in the workbook, and the Name Manager can still be accessed and this also shows all names in the workbook, even those in locked and hidden cells. Cheers. "Ms-Exl-Learner" wrote: Just select the cells for which you have applied the formula and do right clickFormat CellsProtectionTick Both Locked & Hidden Check boxes and give ok. Unlock all the cells which ever you want the people to have access as mentioned below: Select the Columns Or Cells that needs to have the Editing option and do right clickFormat CellsProtectionUncheck Both the Locked & Hidden Check boxes and give ok. Now Protect the worksheet with a password. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Stanley" wrote: Hi, I have a spreadsheet which other people use, but I don't want them to see the cell names I have used. Is there any way to hide the Name Box on the screen, and stop access to the Name Manager ? I thought protecting the sheet and workbook would do this, but it doesn't seem to. Thanks very much. |
Hide Names
Hi Stanley,
Did you ever figure out a way to do this? Thanks Sid On Friday, November 6, 2009 2:20:05 PM UTC, Stanley wrote: Thanks for the reply. This doesnt stop the Name Box being on the screen with the drop-down list of all names in the workbook, and the Name Manager can still be accessed and this also shows all names in the workbook, even those in locked and hidden cells. Cheers. "Ms-Exl-Learner" wrote: > Just select the cells for which you have applied the formula and do right > click>>Format Cells>>Protection>>Tick Both Locked & Hidden Check boxes and > give ok. > > Unlock all the cells which ever you want the people to have access as > mentioned below: > > Select the Columns Or Cells that needs to have the Editing option and do > right click>>Format Cells>>Protection>>Uncheck Both the Locked & Hidden Check > boxes and give ok. > > Now Protect the worksheet with a password. > > If this post helps, Click Yes! > > -------------------- > (Ms-Exl-Learner) > -------------------- > > > > "Stanley" wrote: > > > Hi, > > I have a spreadsheet which other people use, but I don't want them to see > > the cell names I have used. Is there any way to hide the Name Box on the > > screen, and stop access to the Name Manager ? I thought protecting the sheet > > and workbook would do this, but it doesn't seem to. > > Thanks very much. |
| All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com