Ken, yeah, I wasn't sure if that was love or sarcasm, so let's hope I guessed wrong.
And sometimes I leave screen updating on, just so people can see that things are happening. The macro runs slower, but at least they know it's still running, and hasn't hung.
Jon, good question. After some digging I found this -- about a month ago, someone said, "Having a little more fun than I should be playing with conditional formatting in Excel 2007 at work." So far, that's it.
on the article - inserting pictures into comments in excel, does anyone know how to program vba so that the comment automatically takes a picture's address from a cell in the same row and be able to replicate for following rows vs having to manually define the location of the picture for each comment?
"Entering data into excel….I think I missed my calling "
Wow... I felt like that once... when I was 12! (Take your kid to work day, as I recall.)
"there is something about watching an Excel macro run that I find entertaining"
I hope this person just hasn't found "screenupdating=false" part yet... LOL!
Ken, yeah, I wasn't sure if that was love or sarcasm, so let's hope I guessed wrong.
And sometimes I leave screen updating on, just so people can see that things are happening. The macro runs slower, but at least they know it's still running, and hasn't hung.
Hmmmmm. All of the items that mention 2007 are in the second category. Did you see any where the commenter liked the new interface?
Jon, good question. After some digging I found this -- about a month ago, someone said, "Having a little more fun than I should be playing with conditional formatting in Excel 2007 at work." So far, that's it.
on the article - inserting pictures into comments in excel, does anyone know how to program vba so that the comment automatically takes a picture's address from a cell in the same row and be able to replicate for following rows vs having to manually define the location of the picture for each comment?
Jarret, There's a sample file at the following link, that might help you get started. You can adjust the code to match your folders. Debra
http://www.contextures.com/excelfiles.html#CM0003