Excel macro or hyperlink snag
Thread Starter
Join Date: May 2005
Location: WA
Posts: 65
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Apr 2004
Location: Civ/HAL/SHY/FYY/PWK/AAS/WAD/AVI/GPT/BZN/BSN/WAD/BAS/FLK/WIT/MND/WAD/WIT/WAD/Civ
Posts: 373
Likes: 0
Received 0 Likes
on
0 Posts
msgbox
Try this line:
If ActiveSheet.CellProperty(x,y)=value Then MsgBox "warning message about blah blah blah"
If ActiveSheet.CellProperty(x,y)=value Then MsgBox "warning message about blah blah blah"