PDA

View Full Version : Excel macro or hyperlink snag


heated ice detector
27th Jun 2007, 03:34
I made a simple spreadsheet which thru conditional formating will change a grid square's colour when its date has expired or 30 days prior.
Its use is to show when items are due or overdue there life times.
can I thru the use of macros or hyperlinking, make a file with for example "warning" appear on your desktop in conjunction with conditional formating.
All suggestions appreciated.

unclenelli
27th Jun 2007, 13:18
Try this line:

If ActiveSheet.CellProperty(x,y)=value Then MsgBox "warning message about blah blah blah"