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. Can I some how get rid
of this Message Bar? And if so, how? 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 on, tried View/Message Bar uncheck.
This works, but the code is not recorded. Also tried
Application.DisplayAlerts = False but it continues to appear.
Thanks