Replies

Okay, thanks, I will see if I can adapt those to my needs.

Unfortunately, the attachment was lost (with a lot of others) in the server crash of August 2007.

Perhaps you can use the Timecard template – see Use the Excel Timecard template for quick and easy time tracking.

I was searching for this topic so I could make a time tracking worksheet; my search found this post but the attachement is missing or I don’t know where to find it.

Is the attachment available?

Cell F2 contains the time in minutes, but it is formatted incorrectly. If you select F2, then Edit | Clear | Formats, you’ll see the number of minutes (291). I’m not sure what you want in G2, but you should clear the formatting there too probably.

that was the problem… option button border outside group control border. Thank you very much.

Are you sure the option buttons are from the Form Controls section? If so, it should work, provided that the option buttons are completely enclosed within the group box. Take care – the outline of an option button may be larger than the button and its caption!

okay, that makes sense. I created group boxes and put them around the option buttons but it does not seem to have any effect. I also tried deleting the existing option buttons and creating new ones… no difference. I don’t think I am getting the option buttons inside the group control… any ideas?

Have they been created from the Form Controls section of Insert in the Developer tab of the ribbon?

If so, you have to place the option buttons that belong together within a group box from the Form Controls section. Option buttons within a group box behave as a group, independently of other option buttons.

Thanks, took me a while to figure out. In 2007 (maybe others), you have to have made the macro first then go through the customization. Otherwise, when you select macros… there is nothing from which to choose.

Click the Office button.
Select Word Options from the menu.
Click Customize in the navigation pane on the left.
Select Macros in the Choose Commands From dropdown.
Select the PasteUnformatted macro (or whichever macro you want to add)
Click Add>>.
Click OK.

Okay… but how do I actually create a button to be placed there? I can’t find any option for adding buttons through customization… unless I am looking in the wrong places.

On the Quick Access Toolbar (by default next to the Office button)

This is great but… how do you make a button in Word? Where does the button appear? On the ribbon?

I would like to put a button on the toolbar of Word2007, that will paste unformatted text.

I have been able to do this in Word2000 by using a macro that was put onto a button. It worked well. But in Word2007, after making the button with the macro, and everything going well, when I click the new button, the result is text that is formatted as in the original document.

Does anyone know how I can paste unformatted text with one click of a button?

Thanks.

Elaine

Thank you all very much. What relief to not see that each time.

This is simply how Track Changes works. You can change how the revision marks display on your own screen, but that is not the same as eliminating them (and anyone receiving the document can change the display on their screen, meaning they also can see markings that normally are intended to be confidential). In order to get rid of the revision marks altogether, you must accept (or reject) all of them.

Jan

Author, “Formatting Legal Documents With Microsoft Office Word 2007″
Available on Lulu.com and on Amazon.com

For Word and WordPerfect tips, also see my (new) blog: http://compusavvy.wordpress.com

Thank you – makes it easier to write & read (but not necessarily understand) the code.

If you want to break a line in Visual Basic code, type a space and an underscore at the place where you want the break, then press Enter. For example:

Code:

If wsh.Range("A24").Value = "0" And wsh.Range("D24").Value = "0" _
  And wsh.Range("G24").Value = "0" Then

Thanks, Hans, it works perectly. How do you make the line break in the VBA window? When I hit enter to go to the next line, I get a compile error: Expected: expression

Your code uses different conditions from what you describe, but apart from that, you should be able to use

Code:

If wsh.Range("A24").Value = "0" And wsh.Range("D24").Value = "0" AND wsh.Range("G24").Value = "0" Then
  wsh.Range("A24:A25").EntireRow.Hidden = True
  wsh.Rows(28).Hidden = True
End If

Thank you very much for the information. Based on what you said, I went back and looked and the menu I sought was, indeed, in the Add-Ins menu group on the ribbon so I can use it as intended. I will pass the info on to my friend who created the SS as he does not have Excel 2007.

If you are ok with the menu items appearing in the AddIns tab in 2007, then you can use the commandbars collection – add a new commandbar and then add your controls to that. Otherwise I think you would need to use a 2007 format file. See Ron de Bruin’s site here, for example.

LOL – that is one option.

I was wondering if there is any way (and how to do it) to create command buttons on the spash page of the SS so that I could invoke whatever menu items would have been available on an earlier verion of Excel.

Uninstall Office 2007 and reinstall Office 2003?

Not a single comment from the collective wisdom? If unable to have the original menu structure… how might I make it useful in Excel 2007?

A friend recently gave me a SS he created that had some code for making a new menu tree to the right of the HELP menu found in Excel 2003 and earlier. Problem is, Excel 2007 has no such HELP menu item. How can I get it to work? I have attached the file.

Cool – thanks Dave

Check out http://www.noveltieswholesale.com/files/millionbill.jpg%5B/url%5D

I take it, then, that retaining those yes/no fields in the main table is the biggest constraint. If I were to forgo those and, instead, have little subforms for games the Dealers know, and venues they will work, and availability, then it would be simpler to have the functionality I desire… although not the look. Is this correct?

I took a look at your database. Implementing the suggestions I gave you higher up in this topic would be possible, but it would take more time than I can afford to spend on it. Perhaps someone else is willing to do so, otherwise it might be a good idea to give it to a professional Access developer.