+ Reply to Thread
Results 1 to 3 of 3

how to prevent users able to perform cell actions except cell range selection

  1. #1
    Forum Contributor
    Join Date
    10-01-2010
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    101

    how to prevent users able to perform cell actions except cell range selection

    I am looking for code that makes it possible for the user to select a cell range as requested by InputBox commandbutton code to merge and populate these cell range, but prevents the user at any time to perform any modifications like deleting/changing values etc, unless by a code from another commandbutton that deletes the cell values.

    So, it is like the cells are protected, but commandbutton code is able to perform any action.

    Command buttons already in place and working, but I am looking for a block users can to perform actions manually, beyond these commands

    Bart
    2003
    Last edited by vdongen; 10-08-2010 at 09:47 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: how to prevent users able to perform cell actions except cell range selection

    Protect the worksheets when the workbook opens using the userinterfaceonly:=true argument and then the code will be largely able to do what it wants whilst the user cannot. Note: you do have to do this each time the workbook opens.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    10-01-2010
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    101

    Re: how to prevent users able to perform cell actions except cell range selection

    Thanks, that did the job.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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