Thread: Please Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gunjani
 
Posts: n/a
Default Please Help

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.