Results 1 to 4 of 4

Prevent user from modifying first row

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    France
    MS-Off Ver
    2010
    Posts
    260

    Prevent user from modifying first row

    Hi,

    I'm trying to prevent the user from playing with A1:AB1. I've tried protecting that range but it's seems like a hassle to unprotect when macro runs/protect when macros ends and protect first time user opens the workbook.

    I've opted for the Worksheet_SelectionChange option which is fine by me however I run into a problem when user selects a column or the entire sheet.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    
    If Target.Row = 1 Then
        Target.Offset(1, 0).Select
    End If
    
    End Sub
    I understand I can't offset the row in these situations but I can't find the code to modify it. Say offset by one row when users selects column but let the user select the whole sheet. Any ideas ?

    Thanks,
    amphi
    Last edited by amphinomos; 01-07-2015 at 10:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-19-2014, 04:22 PM
  2. Prevent other users modifying code
    By aguy01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2012, 10:41 AM
  3. User Stamp when Modifying a Cell
    By cg0789 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2012, 12:59 PM
  4. Prevent user from modifying
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2011, 08:08 PM
  5. How to prevent the user to update the user defined style
    By nnram123 in forum Word Formatting & General
    Replies: 0
    Last Post: 07-27-2010, 01:52 AM

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