ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Please Help (https://www.excelbanter.com/excel-worksheet-functions/80302-please-help.html)

Gunjani

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.



All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com