Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Cells locked after Protection

  1. #1
    Join Date
    21st September 2011
    Posts
    2

    Cells locked after Protection

    I have created macros on sheet, and unlocked few cells which I am considering as input. After protecting this sheet, first time unlocked cells are accepting data. After copying data and ran the macro, got the result. After getting results, these unlocked cells turned to locked automatically. Can anybody provide solution for this.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    India
    Posts
    1,039

    Re: Cells locked after Protection

    Hi Chkirankumar:

    All formats in the cells being copied will paste to the cells where you are pasting. So the cells you are copying has the format "Locked".

    After pasting your data into the cells, unlock the cells again and save.


    Hope this helps.

    Regards



    Maqbool

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    21st September 2011
    Posts
    2

    Re: Cells locked after Protection

    Thanks Maqbool,

    i have copied data from a website into Excel cells. I am using this sheet for automation, everytime i cannot unprotect and protect. Protection is required for avoiding changes by other users.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Cells not being Locked correctly
    By chezral in forum EXCEL HELP
    Replies: 2
    Last Post: November 22nd, 2010, 21:14
  2. Cells Remain Locked
    By M40wen in forum EXCEL HELP
    Replies: 5
    Last Post: June 5th, 2007, 00:19
  3. Locked Cells
    By shane in forum EXCEL HELP
    Replies: 5
    Last Post: February 23rd, 2005, 08:13
  4. Format Locked on certain cells
    By pt5014 in forum EXCEL HELP
    Replies: 8
    Last Post: April 1st, 2004, 05:22
  5. [Solved] locked cells
    By jcsmithy in forum EXCEL HELP
    Replies: 1
    Last Post: March 19th, 2004, 04:55

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
  •  
porno