Results 1 to 6 of 6

Column lock by Date in excel VBA

Threaded View

rain4uu Column lock by Date in excel... 10-04-2013, 08:03 AM
jaslake Re: Column lock by Date in... 10-09-2013, 11:11 AM
rain4uu Re: Column lock by Date in... 10-09-2013, 03:05 PM
jaslake Re: Column lock by Date in... 10-09-2013, 03:26 PM
rain4uu Re: Column lock by Date in... 10-11-2013, 02:30 AM
Fotis1991 Re: Column lock by Date in... 10-11-2013, 02:35 AM
  1. 10-04-2013, 08:03 AM #1
    rain4uu is offline
    Registered User
    Join Date
    04-16-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    33

    Column lock by Date in excel VBA

    hello,
    I want to lock column on bases of the date that appear on the top of the column, if the date shown in cell A1 is today's date then column containing previous days date should be locked automatically (entire Column). sheet appears as attached here.
    Attached Files Attached Files
    Last edited by rain4uu; 10-05-2013 at 08:38 AM. Reason: No Replys
    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. How do I lock the date when I enter data to highlight a cell dependent on that date?
    By filzen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-01-2013, 07:38 PM
  2. Lock Excel Column when the date in system expires
    By benedictine191 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2012, 12:55 AM
  3. lock all cells before current date (Dates are in Column)
    By Sanoj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2012, 12:36 PM
  4. lock all cells before current date (Dates are in Column)
    By Sanoj in forum Excel General
    Replies: 3
    Last Post: 03-07-2012, 11:04 AM
  5. lock moth for a date column
    By ladyhawke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2006, 03:35 AM

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