#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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"