Replies

I am having the same problem. However, I checked my email settings and that box was not checked.

Still looking for a solution.

I had read that. I only had two macros, deleted them and still didn’t work.

No add-ins – except WOPR Commander – nah, that wouldn’t do it.

Bring up the “Customize toolbar” (Menu > Tools > Toolbars > Customize). Then you should be able to right-click on the button and at the bottom should be a menu item “Assign macro…” Is it not there?

If it is, then releasing the mouse will bring up the macro listing box. Select the one you want and click okay. The box will disppear. Then close the customize toolbar dialog box.

While I am behind a firewall, just copying from a presentation on my own computer then opening Word to paste still empties the clipboard. Note, it is not that I can’t copy and paste if Word is already open; it only is when I copy when Word has not been launched. Then when Word launches it empties the clipboard.

No, this is still a problem just using PowerPoint, copying, then opening Word. on my own computer.

It also occurs with IE (but not exclusively.).

Although I am behind a firewall, I don’t have Zone Alarm or anything else like that. And that still should not affect two programs on my own computer.

I have been frustrated several times when I select some text in another program and copy, then launch Word so that I can paste it in. However, when Word launches, the clipboard is always emptied. No other program does this (Access, Excel, PowerPoint).

Is this meant to be a “feature”? Is there a way to get around this?

Not sure if this is what you what, but Microsoft has a “Delete Links” Add-in that might already solve your problems. Check MS web site.

Thanks, Peter. Yes, I tried that, and any other combination of the above. While the Office Assistant responds to changes in these options, the toolbars do not.

But the very first thing I did after installing Office XP software was to get rid of the Office “Assistant” – i.e. I hide the “Assistant”; but the behavior (of the Toolbar moving) still occurs.

Yep, Jim. I found that same Help topic on Monday night. Went to customize, and sure enough that dialog option for transparent toolbars is not there.

Thanks, Jim, at least I know I’m not nuts.

BTW, I checked with others in our corporation and they have the same “problem.” The corporation has 75,000+ employees, so it must be a definite “feature” that doesn’t match with the Help file.

Well, no matter which toolbar I use, even the standard ones, if I move them away from the docking position, then the toolbar will move everytime I select rows or columns ((and even just a range of cells, it doesn’t have to be the entire row) that adjoin where the toolbar is. In other words, it is “floating” only to the extent that I can move it around. But once I select row/columns/cells, then the toolbar tries to “move out of the way” – The toolbar acts as if a snowplow is pushing it. Once it gets to the top, it will jump over the standard tool bars, to the very top of the screen, but not docked.

I never had this issue with Excel 97 (or at home with Excel 2001 on a Mac); but it has been there since day 1 of Excel 2002.

I have attached a Word file that has a screen shot of Excel. This is only an example. I placed the toolbar so that the upper left corner of it was above cell F6. Then I went to the left side and began selecting rows 5-11. As I got to row 6, where the toolbar was, the toolbar began sliding down to its present position, as I continued selecting rows.

Am I making sense?

I’m not sure what is happening. I had no problems with this when using Excel 97 on Windows 95. Using Excel 2002 on Windows 2000, the toolbars move – never did with the old set up. And this is a toolbar, not a button, set up exactly the same way in Excel 97. The problem with attaching this toolbar to the worksheet is that I have to do it to all 78 workbooks.

I just tried the standard toolbars that are always available. When I pull them off the top, then select rows (on the left side), then selecting process moves the tool bar down or up, depending on which way I select the rows. Same is true if I select columns. The tool bars move right or left depending on the direction of selecting.

Of course, if I dock it solidly on the right side, then it doesn’t move. The problem is that my descriptive tags for each macro then runs up and down – making it difficult to read.

Yes, you can have a range of cells, one column wide. Just go to Insert > Name > Define, give the range a name (no spaces) (i.e. Source), identify the range, click Add.

Then go to Data > Valdiation > select list from the dropdown list, and in source type “=Source” (without the quotes). Click Okay.

For multi-column, you will need the combo box, I think.

The Concatenate function is not difficult. Set it up for one cell (i.e. D3) which has =concatenate(b3,c3) or if you want a space between them =concatenate(b3,” “,c3) . Then fill down (by double-clicking the fill symbol, or by dragging in the normal “fill” way).

If you name the range of concatenated values (as above), then you can reference it in the validation reference (see above), and then hide the column that has the concatenation (i.e. column D). Should be the best of both worlds.

Yep, sorry. I was protecting all sheets (through a macro I use), but not the workbook.