Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I received this suggestion ( in quoted marks) but it does not state
where it should be entered. Is it a Macro in a toolbar? "You COULD use Application.DisplayFormulaBar = False but the user can undo that if he knows how. You could also remove the command to turn it back on: Commandbars("Worksheet Menu Bar").Controls("View").Controls("Formula Bar").Enabled = False but then the user can turn it back on from Tools/Options. But you can turn THAT off with Commandbars("Worksheet Menu Bar").Controls("Tools").Controls("Options...").Ena bled = False Be sure to turn them all back when done!" If it is a macro can someone send me an idiot guide on how to enter the above suggestion. I tried to contatct the original author but he/she has not responded for two weeks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|