Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Customizing XP Invoice Template

  1. #1
    New Member
    Join Date
    May 2002
    Location
    New Jersey
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Spoiled by XL2000. Need to put logo and change fonts on XP Invoice template. Is this possible--without using power tools? (I need this for students in an application class if it is doable.)

  2. #2
    New Member
    Join Date
    May 2002
    Location
    New Jersey
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm new to the Board, and not sure of the message here... Does "no comment" mean it is not doable, or too complicated for non-VBA users, or something else?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think it probably means people aren't sure what you mean. As a wild guess you could include a logo inside a picture frame, and different fonts etc can be set for labels and textboxes in their design properties or via code. Could you be a bit more specific- you current code and what, exactly, you want to do?

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 15:57, CompTutor wrote:
    Spoiled by XL2000. Need to put logo and change fonts on XP Invoice template. Is this possible--without using power tools? (I need this for students in an application class if it is doable.)
    Hi CompTutor:
    I am using Excel 97 ... and I have access to an Invoice Template -- I believe Excel 2000 will have a simila if not identical template. In Excel 97 Invoice Template, near the top right hand corner is a command-button 'Customize' -- clicking on that takes me to another screen which facilitates changing through two command-buttons 'Change Plate Font' and 'Select Logo'.

    Hope This Helps.

    Regards!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ah, sorry, didn't realise this was a built in form- I thought you were posting about a custom UserForm (thanks, Yogi, not for the first time ).

    I have Excel 2000 here, and there seems to be no problem with customising the template. Could you post exactly what you want to do, and how you're prevented from doing it, I'd be very surprised if Excel 2000 messed this up compared to '97.

  6. #6
    New Member
    Join Date
    May 2002
    Location
    New Jersey
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for clarifying the non-response--I was getting worried!
    Mudface, I want to teach the students to use (abuse) the ready-made Invoice template in Excel XP in an applications class, before we get to making our own. What I want to do in XP is EXACTLY what you describe in 2000/97, Yogi. But the XP template doesn't have the customize button, and I don't know what method to use to enable me to make any changes besides text--it doesn't let me change fonts, and there is no obvious way to put in a logo like we had in the 2000 version, with a click of the button. What I am hoping is that there is a less-obvious (but non-VBA) method for letting us do this.


  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, your original post said Excel 2000, I don't have Excel XP (or the OS) so I don't know what, if anything, has been changed in the template. It might be worthwhile reposting and specifying Excel XP in your question.

    [ This Message was edited by: Mudface on 2002-05-11 15:32 ]

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-11 14:44, Mudface wrote:
    Ah, sorry, didn't realise this was a built in form- I thought you were posting about a custom UserForm (thanks, Yogi, not for the first time ).

    I have Excel 2000 here, and there seems to be no problem with customising the template. Could you post exactly what you want to do, and how you're prevented from doing it, I'd be very surprised if Excel 2000 messed this up compared to '97.
    Hi Mudface:
    That's what the cyber-buddies are for -- have a great evening.

    Regards!

  9. #9
    New Member
    Join Date
    May 2002
    Location
    New Jersey
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, guys, for the attempt. I played around with it some more, and tried unprotecting it, and it not only LET me, but I can now edit it and save it as my own template! Appreciate the discussion. Great board. (Actually, Mudface, although I realize my first line was distracting, it does say XP in the title...) Have a great Mothers' Day--we are all Mothers to someone sometime.

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    down version of Excel will work, so you can just use the as before until you solve the XP issues,

    XP supplies the same village software as older Excel version.. and they seem to be just the same.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •