+ Reply to Thread
Results 1 to 2 of 2

Protecting Named Ranges' Names and Disabling Name Manager

  1. #1
    Registered User
    Join Date
    03-16-2016
    Location
    indiana, US
    MS-Off Ver
    2016
    Posts
    33

    Protecting Named Ranges' Names and Disabling Name Manager

    Hello,
    I have a program with named ranges. I am in the process of protecting everything. I have over 500 named ranges and want to protect them (the names). How do I do this and still allow the user to input values in the cell? In a perfect world I would like for them to be able to see the name in the name bar, but not be able to edit or delete it.

    Also, is there a way to prevent the user from seeing any of the named ranges in the Name Manager?

    Thanks in advance,
    Dustin

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Protecting Named Ranges' Names and Disabling Name Manager

    The best way to protect information in Excel is to have the next kinds of WB:
    1 for input data, very simple structure
    2 for checking errors in 1
    3 for cosolidating and computing info in 1

+ 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] Code to create named ranges, overwriting where names may already be in use
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-26-2016, 04:33 PM
  2. [SOLVED] How to extract names for the 'named ranges' in the selected area
    By billj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2015, 07:22 AM
  3. Copy ranges of cells using names from the Name Manager - Macro Needed
    By Thor55 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2014, 10:19 AM
  4. Replies: 3
    Last Post: 08-20-2012, 08:56 PM
  5. Disabling Visual Basic Editor After Protecting Worksheet/Workbook
    By Reggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2006, 09:40 PM
  6. protecting formulas with named ranges
    By Robin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2005, 11:05 PM
  7. range names-How do you progammaticly refer to named ranges?
    By Zoomer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2005, 05:06 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