LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent Tab from User Delete Ardy Excel Worksheet Functions 2 September 9th 09 02:38 PM
Prevent user from using Name Matlock Excel Discussion (Misc queries) 5 March 13th 08 04:58 AM
Prevent user moving to next control johncassell[_11_] Excel Programming 7 July 31st 05 08:12 PM
Prevent User from saving crapit Excel Programming 2 July 26th 04 03:48 PM
How do I: prevent user from scolling down and right? jasonsweeney[_39_] Excel Programming 3 February 5th 04 07:06 PM


All times are GMT +1. The time now is 02:33 AM.

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

About Us

"It's about Microsoft Excel"