Results 1 to 2 of 2

Protecting Selected Cells and Functions

Threaded View

johnlovesbeer Protecting Selected Cells and... 12-07-2009, 04:31 AM
royUK Re: Protecting Selected Cells... 12-07-2009, 04:56 AM
  1. #1
    Registered User
    Join Date
    09-15-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    58

    Protecting Selected Cells and Functions

    Hi all,

    I have a created a sizeable project which involves 3 different sheets with various dropdown selections, sort filters and formulas. I need to be able to protect the size of rows and columns, functions of the dropdowns, filters, cells containing formulas and fixed data cells but still allow the users access to choose from dropdowns, sort, and input data into blank cells when required. In short I have to make it as close to fool-proof as possible. I've had a look at various tutorials but nothing has really satisfied.

    Cheers,

    JLB.
    Last edited by johnlovesbeer; 12-07-2009 at 04:55 AM.

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