View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. m0le[_2_] Mr. m0le[_2_] is offline
external usenet poster
 
Posts: 17
Default Can't unshare workbook

Update: I came up with something that worked.... I copied each individual
sheet out of the workbook into a new workbook and the shareing and protection
was removed and i can import txt files and such again. Sry for any
inconvience i may have caused anyone if you where tryin to help me out with
this problem.

"Mr. m0le" wrote:

I have a workbook with two marcos in it. I set it to share as it was going
to be passed around untill i realized that you can't import txt files into
the workbook while it's shared. I tried to go into tools, protection,
unshare and it changes the option in the menu to show share & protect but the
workbook itself is stuck on share in the title bar and i still can't import
txt files or anything. I've tried to save it this way and reload and other
such combinations without luck. Is there a way i can get this workbook
unshared completely so i can import txt files into it again?