Prev: No print settings in Excel HTML files
Next: Locked cells
From: carmjo005 on 1 Feb 2010 15:40
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?
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 View/Message Bar uncheck. This works,
but the code is not recorded. No luck so far searching for the answer.
Thanks

 | 
Pages: 1
Prev: No print settings in Excel HTML files
Next: Locked cells