PPRuNe Forums - Excel macro or hyperlink snag

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - Excel macro or hyperlink snag (https://www.pprune.org/computer-internet-issues-troubleshooting/281724-excel-macro-hyperlink-snag.html)

heated ice detector

27th June 2007 03:34

Excel macro or hyperlink snag

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 June 2007 13:18

msgbox

Try this line:

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

All times are GMT. The time now is 14:48.