ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide Message Bar (https://www.excelbanter.com/excel-discussion-misc-queries/255118-hide-message-bar.html)

carmjo005

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
€śServer Workbook To modify this workbook, you must check it out €ś followed
by a €śCheck Out€ť button. How can I get rid of this message bar? From within
the macro, or within the settings? (Excel 2007)
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, tried View/Message Bar uncheck. This
works, but the code is not recorded.
Thanks in advance



All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com