workbook with code to transfer rows to main sheet works perfect until set up to share workbook

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: workbook with code to transfer rows to main sheet works perfect until set up to share workbook

  1. #1
    Board Regular
    Join Date
    Feb 2013
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default workbook with code to transfer rows to main sheet works perfect until set up to share workbook

     
    I have a workbook built that takes the last 2 rows on one sheet and transfers them to a main sheet. When I change this workbook to allow sharing it still tranfers the data but not the unmerges cells and does not transfer the formating. When I turn off sharing everything works again. Does anyone have any ideas why this would happen, and how to stop it?

  2. #2
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,369
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: workbook with code to transfer rows to main sheet works perfect until set up to share workbook

      
    There are too many potential issues with shared workbooks - including possible 'corruption.
    Best to avoid using them.
    Avoiding Shared Workbooks in Excel | Contextures Blog
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com