I had orginally designated a workbook as shared. Now the workbook is no
longer designated as shared. To make matters worse, the "Share
Workbook" option in Tools is not available (it is shaded out). Did I
make an error in some setting?

I am having a similar problem with a couple of my worksheets and can't
figure out a reason why it won't let me share these, any
ideas/solutions would be appreciated.

Thanks in advance.


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=549122

I have found the problem (via another thread) you cannot share a
workbook that contains lists (though excel doesn't tell you this), you
need to go through the workbook and select each list you have created
and either remove it or convert it to a range instead.


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=549122