Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Message Bar
I have a series of macros that modify data in a protected workbook. Only
certain users have permission under SharePoint to run the macros and modify the data. At the end of the macro it displays a worksheet (read only) with the current edited data visible for all to see. But I also get a Message Bar (Excel 2007 - below ribbon) €śServer Workbook To modify this workbook, you must check it out €ś followed by a €śCheck Out€ť button. How do I get rid of this? From within the macro, or within the settings? Ive tried Excel Options/Trust Center/Trust Center Settings€¦/Message Bar/ Never show information about blocked content, without success. And with the Message Bar displayed and Record Macro View/Message Bar uncheck. This works, but the code is not recorded. No luck so far searching for the answer. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Message Bar | Excel Discussion (Misc queries) | |||
Hide Message Bar | Excel Discussion (Misc queries) | |||
Getting error message when trying to hide a column | Excel Discussion (Misc queries) | |||
Hide Error Message | Excel Discussion (Misc queries) | |||
How do I hide a formula message? | Excel Worksheet Functions |