+ Reply to Thread
Results 1 to 1 of 1

Formula or VBA code to restrict data entry to certain cells during 3 different time blocks

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula or VBA code to restrict data entry to certain cells during 3 different time blocks

    Hello. I need either a formula or VBA code that will do the following:

    Restrict numeric data entry (1) in cell C45 from 7am-4:59am; (2) in cell C46 from 3pm-12:59pm; (3) in cell C47 from 11pm-8:59pm.

    Each cell should only be enabled during 2 hours each day.

    Any help on this would be greatly appreciated.

    Thank you in advance and have a great day!

    Z
    Last edited by lazinia; 11-06-2012 at 04:12 PM.

+ Reply to Thread

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