+ Reply to Thread
Results 1 to 4 of 4

How to protect the formatting of unlocked cells

  1. 12-14-2014, 05:57 AM #1
    Baldev Kumar
    Baldev Kumar is offline
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    How to protect the formatting of unlocked cells

    Looking for help to protect the formatting of editable cells of worksheet.
    Is there any trick to protect the formatting of editable cells even if some one copy paste the data from some other workbook.
    password to unprotect the sheet is 12
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-14-2014, 06:05 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,194

    Re: How to protect the formatting of unlocked cells

    When you protect the sheet, uncheck select locked cells. That should do the trick for you...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 12-14-2014, 06:21 AM #3
    Baldev Kumar
    Baldev Kumar is offline
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: How to protect the formatting of unlocked cells

    Thanks for quick reply.
    i tried this but not working. e.g. copy cell h5 and paste using Ctrl+V in cell f6, this will also paste the format of cell h5. I have set the date format for the f column,
    it should be remain intact
    Reply With QuoteRegister To Reply
  4. 12-14-2014, 07:24 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,194

    Re: How to protect the formatting of unlocked cells

    Try this then...
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can I protect a sheet but allow text formatting (but only in certain unlocked cells)?
    By Rob T in forum Excel General
    Replies: 2
    Last Post: 09-11-2014, 07:28 AM
  2. Enforce formatting in unlocked cells
    By ddgacic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:57 AM
  3. [SOLVED] How do you protect multiple sheets while only allowing users to select unlocked cells?
    By mrssteelerhall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2013, 02:05 PM
  4. I want to prevent the copy funtion for a range of unlocked cells in protect w/s
    By excel1z008339 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 01:10 PM
  5. Protect unlocked cells in a protected worksheet from cut/pasting
    By Jerry NeSmith in forum Excel General
    Replies: 0
    Last Post: 11-29-2005, 05:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1