MrExcel Publishing
Your One Stop for Excel Tips & Solutions

2 questions inside..


Posted by JUBOR on July 10, 2000 5:28 AM

1. is is possible to use hidden cells while u r using unprotectedsheet
i mean i want my formula not been seen by user..but i can't protect
the sheet..


2. is there any code that can prevent user from using view n can
choose formula bar..i want the formula bar to be deactivate.

any ideas.thanks


Posted by Ryan on July 10, 0100 6:23 AM

JUBOR,

If you need the formula hidden and not a locked cell, you can just unlock the cells and check the hidden box, and then protect the worksheet. As for the formula bar, here is the code:
Sub ToggleFormulaBar()
' This code Toggles the Formula Bar. Or you can put either "= False" or "= True"

Application.DisplayFormulaBar = Not Application.DisplayFormulaBar

End Sub

Posted by JUBOR on July 10, 0100 8:06 AM

Ryan,

i copy the code but it's not working..could u explain it more detail..i mean
about the code and how to display it.i'm just a beginner.hope you don't mind
thanks

If you need the formula hidden and not a locked cell, you can just unlock the cells and check the hidden box, and then protect the worksheet. As for the formula bar, here is the code:

Posted by Ryan on July 10, 0100 12:11 PM

You need to put the code into a module window for the workbook you are working in or put it in your "PERSONAL.xls" workbook. The code that I gave you will display the formula bar if it's gone or take it away if it's there. Put the cursor anywhere within this code and hit F5 to run the code. Don't know what else to say, hope this helps.

Ryan