Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: copy cells from a protected workbook to anouther

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi all, Is there anyway to copy from one protected workbook to anouther? I copy the data,click my cmd button to open my other workbook, And somehow it does not remember the data. Thx Dan

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dan,

    Have you tried linking the cells ? ie in the destiniation cell type :

    =[protectedbook]Sheet1!$A$1

    Could you also explain a little more about the proection on the file ? As there must be a dozen different ways to protect a a file it could be any number of things. I you need to get the file un-protected then I should be able to do that for you.

    Iain

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Iain, The problem with linking, is the information or collums neaded could change,and the original workbook will not be saved with the information entered. The protection I am using is the basic Protect "Sheet" (all checked), Protect "workbook" (windows only). I am trying to supply a "extra" workbook that If someone neaded to create a custom report, the can copy the rows and collums that they nead From my "Protected Workbook" and paste the information neaded in there own .xls file (Unprotected),where they can do what ever. Thx Dan

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    open the workbook first do all that is needed first then copy the data.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thx brettvba, It works fine. Just have to open the other workbook before I start doing my updates. Have a good one thx again Dan .

Some videos you may like

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
  •