Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

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


Check out our Excel VBA Resources

Re: 2 questions inside..

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


Re: 2 questions inside..please help Ryan

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:


Re: 2 questions inside..please help Ryan

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.