Results 1 to 4 of 4

Protecting Cell Format but allowing cell data entry

Threaded View

  1. 10-10-2014, 02:56 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Protecting Cell Format but allowing cell data entry

    Hello telcocook,

    Please try the attached sample Workbook.

    All you need to do, is to change the Code to refer to your specific Sheet where you would like it to work.

    Hope that helps.

    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Allowing manual entry into a cell but maintain cell formulas
    By Cipher Coder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 04:50 PM
  2. Protecting a sheet and allowing validation entry to be deleted still
    By NJS1982 in forum Excel General
    Replies: 1
    Last Post: 04-27-2012, 02:07 PM
  3. Protecting a cell, but allowing the drop down list to work.
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 09-10-2009, 01:13 PM
  4. Protecting a cell from user input and allowing a query access to change values?
    By djwest in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-20-2009, 10:40 PM
  5. Visual Basic - Not allowing cell entry
    By emad1001 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-21-2008, 03:47 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1