Replies

On point a:

I’ve never used it myself, so can only offer you the online help (for XP):

[indent]

---

Open the Whiteboard in an online meeting
Only the host of an online meeting can open the Whiteboard (Whiteboard: Microsoft NetMeeting feature that opens a separate window in which online meeting participants can type text; draw shapes; copy, paste, and delete objects; and highlight or point to text and graphics.) when Windows NetMeeting is used from within Microsoft Office.

On the Online Meeting toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, use the Customize dialog box (point to Toolbars on the View menu and click Customize). To see more buttons, click Toolbar Options at the end of the toolbar.), click Display Whiteboard .

Tip:If you want to prevent participants from changing the shared document but allow them to draw or type simultaneously on the Whiteboard, on the Online Meeting toolbar, click Stop others from editing .

---

[/indent]

so basically, it’s a scratchpad for netmeeting when you’re discussing any office document, and not specifically related to excel.

on point b,

I don’t think you can highlight as such – I’ve never come across it – but you can select part of a cell entry and format that independantly of the rest of the entry – it’s just the formatting capabilities don’t extend to the background of the text.

add the line

Activeworkbook.Close

immediately after the .SaveAs line.

Change the line:

.SaveAs FileName:=ActiveSheet.Name

to something like:

.SaveAs FileName:= “H:FolderAFolderB” & ActiveSheet.Name

Steve,

a) I can’t see any other statistical functions in the ID range 1 to 5400, so I think you’ll have to roll your own.

I don’t think any of the boxes at the right hand side of the status bar are exposed to the vba object model. That said, it may still be possible with API calls as I have seen (in the dim and distant past) an add-in written to widen the drop-down name list box on the formula bar.

HTH
Brooke

Steve,

a) I can’t see any other statistical functions in the ID range 1 to 5400, so I think you’ll have to roll your own.

I don’t think any of the boxes at the right hand side of the status bar are exposed to the vba object model. That said, it may still be possible with API calls as I have seen (in the dim and distant past) an add-in written to widen the drop-down name list box on the formula bar.

HTH
Brooke

Glad to hear it’s fixed – even if my reply was of no help!

Glad to hear it’s fixed – even if my reply was of no help!

I had a similar – though intermittent – problem with filters in xl2k when I first moved to it – I seem to recall that a service pack install fixed it but can’t remember which one. (FWIW, I occaisionally get colleagues complaining of this in XP as well). If service packs don’t work, try working through Jan Karel’s starpost on behaviour problems and see whether that helps.

I had a similar – though intermittent – problem with filters in xl2k when I first moved to it – I seem to recall that a service pack install fixed it but can’t remember which one. (FWIW, I occaisionally get colleagues complaining of this in XP as well). If service packs don’t work, try working through Jan Karel’s starpost on behaviour problems and see whether that helps.

Is this any help? (It’s XP, can’t currently check 2K)

Dim shpConnector As Shape
Set shpConnector = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 147.75, 152.25, 136.5, 87#)
With shpConnector.ConnectorFormat
.BeginConnect ActiveSheet.Shapes(“AutoShape 2”), 3
.EndConnect ActiveSheet.Shapes(“AutoShape 3”), 1
End With

Is this any help? (It’s XP, can’t currently check 2K)

Dim shpConnector As Shape
Set shpConnector = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 147.75, 152.25, 136.5, 87#)
With shpConnector.ConnectorFormat
.BeginConnect ActiveSheet.Shapes(“AutoShape 2”), 3
.EndConnect ActiveSheet.Shapes(“AutoShape 3”), 1
End With

Thanks for the tip, Hans – and yes you are right about my dislikes!

Thanks for the tip, Hans – and yes you are right about my dislikes!

It would seem so – just to keep a count, it was registering two before I voted at the link you provide – when did the file go up? and judging from the screenshot when i tryed to climb back up the heirarchy, there’s definately something odd about that part of the site!!!

It would seem so – just to keep a count, it was registering two before I voted at the link you provide – when did the file go up? and judging from the screenshot when i tryed to climb back up the heirarchy, there’s definately something odd about that part of the site!!!