Protecting Column Widths
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Protecting Column Widths

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a bit of a dilemma. I need to only protect the width of my columns. As my users need to have the ability to add/delete rows, make changes to date/text cells, but not be able to adjust the column width.

    Is this possible?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I'm not sure if this is the best way of dealing with this but you insert following code into the Worksheet module:

    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    Columns("F:F").ColumnWidth = 20
    End Sub

    The user can try and modify the column width but the moment they move to another cell the width will return to your deafult.

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
  •  

 

 
DMCA.com