Hi,

I have confirmed the issue with Excel expert that this error is the
expected behavior, as noted in the error message. Because you have used
the "Share Workbook¡*" command to share the workbook, Excel disables
certain object model methods and properties. The methods and properties
that are disabled will return the error you're seeing. It doen'st matter
whether you're the only one with the workbook open or not.

If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.