![]() |
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