+ Reply to Thread
Results 1 to 3 of 3

Disable all cells not in use on a sheet.

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Disable all cells not in use on a sheet.

    Hi there I would like to know if the following is possible:

    I have several cells in a column for the user to input data, and then a "submit" button.

    It is a very basic sheet to take user input and store it on another sheet and then manipulate(pivot) and display(graphs) on respective sheets.

    Is it possible to remove gridlines and disable all cells on the input sheet except for those that take input, currently validation cells. The main reason is when the user hits tab or lets say enter it moves to the next field for data entry as opposed to through the two empty cells between that are there for spacing. Also to disable them from editing the text that poses the questions(labels): "Please select a Name"...

    Any input will be greatly appreciated. Thanks in advance!

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Disable all cells not in use on a sheet.

    By default all cells in a worksheet are locked. However this only has effect when you protect the worksheet.
    If you select the cells you want to allow input in and on the ribbon on the Cells tab unselect the "Lock cells" option the selected cells will be open for input after you protected the sheet.

    You can remove gridlines in the Options-advanced page. Look for the option "Show gridlines" and unselect it.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Disable all cells not in use on a sheet.

    Thanks for the tips, all worked wonderfully!

+ 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. [SOLVED] How to Disable Cell Merging on Single Sheet (without using sheet protection)
    By nuttyengineer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2016, 07:56 PM
  2. Disable printing bar one sheet
    By Ad83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2012, 09:15 AM
  3. New Sheet Add, Sheet visible & Menu disable problem
    By suman.biswas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2008, 06:42 AM
  4. How to disable calculations of a specified sheet
    By mxcaocao in forum Excel General
    Replies: 1
    Last Post: 02-07-2007, 07:45 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