Replies

Code is too complicated, I may make a simple version that shows the problem.

But, you can see the problem outside of code:

Create a simple scatter chart —
In A1:B2, put some data, say 1, 2, 3, 4
Select A1:B2 & press the chart wizard.
Choose XY (Scatter) & take all of the defaults except step 4: tick “As a new sheet”

Fix the other new features of 2003:
Click in the Chart Area & use the arrow keys to navigate to plot area
Resize the plot area to use the upper-left 1/4 of the Chart Area
Click on the Series 1 label & delete it

Now, you should be able to resize the Chart Area, but you cannot. If the height is max, you can change the width. And if the width is max, you can change the height. But, you cannot change both!

BTW, documentation for 2003 says Height & Width are read only, unlike every other version! Agggggggggggg!

Currently trying to use an embedded chart instead of a chart sheet.

The link must have gotten updated. For today, this is correct.

Also, Al, you must have looked on the wrong corner: it’s in Google on the SE corner. You can’t miss it: it will probably show up at a Kentucky “antique store.”

Fantastic! One thing that has helped me is to have a weight milestone. After I have lost some weight, I set a weight that I will not go above. I weigh myself every morning and if I am above the milestone, I either do more exercise or less eating or sometimes both for that day. –Sam

IIRC the ratio from points to pixels is (usually) either 0.75 or 1/0.75

Thanks, Jan Karel! Since XL2K and earlier does not have PointsToScreenPixel…, (which was what I was looking for) .75 is the answer.

Well we tried remotely killing the wrong process which rebooted the computer. That will teach the user to save his work. I offered him some cheese (with his whine), but he declined.

Microsoft is nothing, they’re also going to take over transportation! http://www.foxnews.com/story/0,2933,530366…html?test=faces

I use web-based Lotus Notes at work. It is the worst email program I’ve ever used.

The name of the guard at the main gate at the Air Force base here used to be St. Peter.

Totally amazing, the change in the weather! 21°C (70F) tonight at 10pm in Ohio! Even though it was late, I had to get out and run. Just did 2.5 km, but it was great! –Sam

This has been doing the rounds – pretty funny.

http://www.youtube.com/watch?v=GuMZ73mT5zM

The speaker is Mark Gungor of http://www.laughyourway.com.

His stuff is really good. He makes you laugh so that the truth doesn’t hurt so much! I just started a small group with his lessons last night and it was lots of fun. –Sam

Thanks, Hans. You’re the man!

That’s the problem. My call to SHGetFileInfo returns the handle of the system image list that contains the small icon images (see http://allapi.mentalis.org/apilist/SHGetFileInfo.shtml%5B/url%5D) and I don’t have a file.

In addition to LoadPicture you can get the picture from other controls so, for example, if you have an ImageList named ImageList1,
control.Picture = ImageList1.ListImages(i).Picture
also works. The Picture property is strange: (1) there no documentation on what sort of object the Picture property returns and (2) intellisense gives a Handle Property fro the Picture property, but
Image1.Picture.Handle = Image2.Picture.Handle
crashes with Object doesn’t support this property, so I guess that Handle is readonly.

Agggggggggggggggg!

If you are looking for weirdness, enter P1, Q1 & R1 in the first row and P2, Q2, & R2 in the second row. Then seletct these 6 cells, grab the fill handle, and drag it down to extend the series to row 5. Notice that column 1 & 3 look great: P1 thru P5 and R1 thru R5. BUT, column two has Q1, Q2, Q3, Q4, and then Q1 again. I’ll let you try to figure out why. Q stands for quarter, there are only four, so the series wraps around

Note, if you don’t have fill handles, you get then with Office button, Excel Options, Advanced tab, Editing options.

> need to find out more about her…Lex is VERY secretive
Lex is not secretive: Liz is the one who is secretive, but she usually makes an appearance during the holidays.
What did you think Lex does when he ducks out of your screen?
> about his relationships!!
wrong again, Liz is the only one: it’s relationship

Never mind, Radio buttons also have the Appearance property, so I’m happy. The image was not appearing because I had the FlatStyle set to System, which makes text look better. If the FlatStyle is set to Standard, then the image shows up.