Results 1 to 8 of 8

macro copy paste on protect sheets and hidden within the same workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    macro copy paste on protect sheets and hidden within the same workbook

    hello

    I have a problem, which is as follows.

    I made this macro that can be seen below (with a little help is truth).

    problem now is the following:

    when the sheet that will receive the copy is protected with password, do nothing get nothing ...

    What I do regret to add or?


    COPIARCOLAR sub ()
    '
    'Macro COPIARnovaforma
    '

    Sheets ("new way"). Select
    Range ("a12"). Select
    Range ("a12: ah112). Select
    Selection.Copy
    Sheets ("new map"). Select
    Range ("a12"). Select
    Selection.PasteSpecial Paste: = xlPasteValues, Operation: = xlNone, _ SkipBlanks
    : = False, Transpose: = False
    Application.CutCopyMode = False
    Range ("a12"). Select
    End Sub
    Last edited by Birnen; 08-30-2010 at 01:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1