+ Reply to Thread
Results 1 to 2 of 2

Need your help in blocking user to edit sheet

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    50

    Need your help in blocking user to edit sheet

    Hi,

    There are three sheets in my excel,

    Screen1, Screen2, Screen3

    Screen 1 will have reference from both the other two sheets. And in Sheet 2 & Sheet 3, there are lot of cells which are editable and few of them are non-editable.

    Now what I want is users should be allowed to fill details in the editable fields only with one sheet at a time either sheet2 or sheet3.

    This block should be made between Column B to Column Q of both sheets.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Need your help in blocking user to edit sheet

    http://www.excelforum.com/showthread.php?t=823709

+ 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. Show UserForm with Continue/Cancel buttons, allowing user to edit sheet
    By dancing-shadow in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-16-2017, 05:33 AM
  2. [SOLVED] Show UserForm with Continue/Cancel buttons, allowing user to edit sheet
    By dancing-shadow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2017, 06:48 AM
  3. Unable to edit sheet after hiding User Form
    By seatbelts in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2014, 09:16 AM
  4. [SOLVED] Allow user to edit ranges on a protected sheet
    By aleenkhan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2012, 03:27 AM
  5. Allow user to edit ranges on a protected sheet
    By aleenkhan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2012, 04:46 PM
  6. Trying to edit user permissions under "Allow user to edit ranges" using VBA
    By Whizbang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2009, 05:33 PM
  7. Blocking access to a sheet
    By pilzner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2008, 04:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1