been working on a project for a while and just added a macro to protect the sheets and now getting an error every time I save. It still seems to be working, but disconcerted as no idea what has changed. Can anyone interpret the error message please? thanks Mike
============================
Error Message:
============================
The specified value is out of range.
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.Shape.Delete()
at Microsoft.AnalysisServices.XLHost.Addin.SASlicerCollection.PrepareToSave()
at Microsoft.AnalysisServices.XLHost.Addin.SASlicerHost.PrepareToSave(Workbook _workbook)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivotManager.PrepareSlicerHostsToSave(Workbook workbook)
at Microsoft.AnalysisServices.XLHost.Addin.ThisAddIn.Application_WorkbookBeforeSave(Workbook unwrappedWb, Boolean SaveAsUI, Boolean& Cancel)
============================
============================
Error Message:
============================
The specified value is out of range.
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.Shape.Delete()
at Microsoft.AnalysisServices.XLHost.Addin.SASlicerCollection.PrepareToSave()
at Microsoft.AnalysisServices.XLHost.Addin.SASlicerHost.PrepareToSave(Workbook _workbook)
at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivotManager.PrepareSlicerHostsToSave(Workbook workbook)
at Microsoft.AnalysisServices.XLHost.Addin.ThisAddIn.Application_WorkbookBeforeSave(Workbook unwrappedWb, Boolean SaveAsUI, Boolean& Cancel)
============================