+ Reply to Thread
Results 1 to 7 of 7

Protect or Lock height/width but still be able to edit cell content and other formatting?

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    Nashville, TN
    MS-Off Ver
    2010
    Posts
    9

    Smile Protect or Lock height/width but still be able to edit cell content and other formatting?

    I have a document that I want to maintain the cell height/width, and when I send it to a colleague for review, he keeps changing the rows and columns to be varying sizes. He needs to be able to make other changes to the cells, such as text or background color, so I don't want to completely protect the document so he can't edit content and some formatting. I only want to protect the height and width of the rows and columns so he won't keep changing them.

    Is there a way to do that?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    Hi heatherubs,

    You can write a code in thisworkbook before save event

    Please Login or Register  to view this content.
    So that even if anyone changes the height/width after saving it will become fixed.
    Ravikumar,

    * Please Add Reputation if solved.

  3. #3
    Registered User
    Join Date
    09-19-2017
    Location
    Nashville, TN
    MS-Off Ver
    2010
    Posts
    9

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    Thank you. I tried that, but it didn't seem to work. The colleague I work with will definitely change the column height/width and save his work that way, and send it back to me like that, which I'm trying to prevent. I'd like him to not be able to move column height/width at all.

    The reason I'm trying to lock height and width is because I keep a large volume of columns and rows hidden, and when he selects the entire workbook and changes the height/width, it will un-hide everything I need to keep hidden, which I don't want. It ends up a mess, and he is more likely to manipulate the data he didn't even realize I need in place.

    Alternatively, is there a way to lock the hidden text from becoming viewable again unless a password is entered or something like that? Anything that would keep hidden content where it is would be my first priority, but the code you gave above would be helpful if it would also keep hidden content hidden.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be anywhere in the world
    MS-Off Ver
    power BI
    Posts
    9,005

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    try very hidden option and Protect Workbook (structure)

  5. #5
    Registered User
    Join Date
    09-19-2017
    Location
    Nashville, TN
    MS-Off Ver
    2010
    Posts
    9

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    I didn't know there was "very hidden" capability! Is it possible to select rows and columns to make very hidden, or does it only work on an entire sheet?

  6. #6
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    Hi,

    If you want to protect the sheet then use "Very Hidden".
    "Protect Workbook (structure)" this will protect the structure of the workbook and no one will change or unhide any rows or columns.

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be anywhere in the world
    MS-Off Ver
    power BI
    Posts
    9,005

    Re: Protect or Lock height/width but still be able to edit cell content and other formatti

    my fault
    very hidden is for sheet(s)

    so you need to wait for any VBA solution
    or
    maybe it will help: https://www.extendoffice.com/documen...olumns.html#a1 or this: https://excel.tips.net/T002781_Hidin...g_Columns.html

    in General: I hate if someone rewriting post from above (this is not to heatherubs)
    Last edited by sandy666; 12-13-2017 at 03:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to lock cell width and height for an entire worksheet
    By vaughnahue in forum Excel General
    Replies: 4
    Last Post: 05-31-2018, 10:14 AM
  2. Copy a sheet with all formatting formulas and rows height and columns width
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2017, 09:29 AM
  3. sheets lock for edit or protect sheet but macro can add data
    By sambhaji.gaikwad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2016, 11:55 PM
  4. VBA to lock a workbook to a certain width and height
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2015, 07:42 PM
  5. Replies: 3
    Last Post: 03-22-2013, 12:19 AM
  6. [SOLVED] lock up height & width of the rows and columns?
    By manharji in forum Excel General
    Replies: 0
    Last Post: 07-29-2010, 10:28 PM
  7. [SOLVED] Is it possible to lock the height and width of a cell?
    By Kilgus in forum Excel General
    Replies: 1
    Last Post: 07-19-2005, 04:05 PM

Tags for this Thread

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