Results 1 to 23 of 23

Lock cells after Today's date passed (VBA excel code)

Threaded View

  1. #4
    Registered User
    Join Date
    04-09-2009
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel, Access, Word, PowerPoint 2003
    Posts
    27

    Re: Lock cells after Today's date passed (VBA excel code)

    Well, there will be cells that contain a reservation name before and after today's date. I want to automatically lock all cells from (D7:J7675) prior to today's date (not including today's date) so that no changes can be made unless you have administrative privileges. This is to protect the integrity of the reservation so that when the reserved thing has been used, the user cannot remove their name to illustrate that they did not use it.

    I've attached a sample reservation schedule for reference as to what I mean.

    Please Advise,

    Thank you
    Attached Files Attached Files
    Last edited by rt1306; 04-09-2009 at 10: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