View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
omer omer is offline
external usenet poster
 
Posts: 74
Default Permanently prevent User to see Formula Bar

Hola,
I wonder if there is a way to prevent (permanently) a user to activate the
formula bar while a specific worbook is open. I'm able to hide it inside the
openning macro with the following command:

Application.DisplayFormulaBar = False

However, the user can still go to the ribon menu and activate it back.
I want it top remain hidden until the workbook is closed.

Thank you for your help.
OMER