Hide Message Bar

C

carmjo005

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)
I’ve 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top