Replies

Thanks, that’s the sort of information I was looking for.

But if I didn’t have the reference (which I didn’t) how come the objects and methods worked?

And where should I have looked to tell me that I needed to include this reference?

TIA

What is this “FileSaveAs.Main, courtesy of WOPR” and where do I get a copy?

No, that’s not it, that’s there in the W2K version too. It refers to shapes within the picture, rather than the picture itself.

But the whole point of this is that they should have access to the show/hide macro.

But the whole point of this is that they should have access to the show/hide macro.

Am I right in assuming that anyone who wishes to use this template would have to make all those settings on their machine too?

Am I right in assuming that anyone who wishes to use this template would have to make all those settings on their machine too?

Just noticed your extra message.

I was going to say that, even if it did work, it wouldn’t be any good for the Open macro as that one cannot be recorded.

Can it be done in VBA in the New macro?

P.S. I’m glad to see that not all my questions are dumb ones that I should easily have got the answers for if only I had bothered to look for them!

Just noticed your extra message.

I was going to say that, even if it did work, it wouldn’t be any good for the Open macro as that one cannot be recorded.

Can it be done in VBA in the New macro?

P.S. I’m glad to see that not all my questions are dumb ones that I should easily have got the answers for if only I had bothered to look for them!

Yeah, I just tried

Set rng = ActiveDocument.Tables(1).Range

With rng.Columns(3)
rng.SetRange .Cells(2).Range.Start, .Cells(.Cells.Count).Range.End
rng.Font.Hidden = True
End With

and the effect wasn’t restricted to “Columns(3)”

So I guess I’m gonna have to select the range after all.

Thanks for your help, couldn’t have done it without you!

That’s great, one thing that just caught me out is that I had expected

rng.SetRange .Cell(2, 2).Range.Start, .Cell(4, 4).Range.End

to be a square range of 9 cells but in fact, in a 5×5 table for example, it includes 14 cells:

Row 2 cells 2 to 5
Row 3 cells 1 to 5
Row 4 cells 1 to 4

That’s great, one thing that just caught me out is that I had expected

rng.SetRange .Cell(2, 2).Range.Start, .Cell(4, 4).Range.End

to be a square range of 9 cells but in fact, in a 5×5 table for example, it includes 14 cells:

Row 2 cells 2 to 5
Row 3 cells 1 to 5
Row 4 cells 1 to 4

You could try IrfanView, a freeware program that has received many good reviews.

Here’s another good review, IrfanView is great.

You could try IrfanView, a freeware program that has received many good reviews.

Here’s another good review, IrfanView is great.

Thanks Hans, I’ll try that out soon and report back.