+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Excel change data on open in Technical; Hi, I am trying to create an excel sheet with lists of software and when it expires. Ideally when we ...
  1. #1
    01hanstu's Avatar
    Join Date
    Sep 2007
    Location
    Manchester
    Posts
    148
    Thank Post
    17
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel change data on open

    Hi,
    I am trying to create an excel sheet with lists of software and when it expires. Ideally when we open the sheet we want it to show the ones that expire within say a month it higlights the cell as red.

    Cheers
    - Stuart

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,698
    Thank Post
    335
    Thanked 516 Times in 484 Posts
    Rep Power
    180
    Err unless it's changed recently it should be as simple as putting it into the "open" event

    aka:

    Code:
    Private Sub Workbook_Open()
    
    Run "MyHighlightyMacro"
    
    End Sub
    Steve

SHARE:
+ Post New Thread

Similar Threads

  1. "My Places" on open and save UI
    By originofsymmetry in forum How do you do....it?
    Replies: 0
    Last Post: 8th October 2007, 12:08 PM
  2. VBS Change File on a Certain Line?
    By Samson in forum Scripts
    Replies: 7
    Last Post: 31st August 2007, 10:52 AM
  3. Lost Delayed-Write Data on b2d job
    By randle in forum Windows
    Replies: 18
    Last Post: 2nd July 2007, 01:41 PM
  4. script to change permissions on Reg Key
    By e_g_r in forum Windows
    Replies: 4
    Last Post: 16th February 2007, 05:48 PM
  5. Replies: 2
    Last Post: 2nd May 2006, 10:42 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •