Excel HT Ticket Maker rev. 4.1.2 (9/2/04) - Page 7 - AVS Forum
Forum Jump: 
Reply
 
Thread Tools
post #181 of 449 Old 01-26-2005, 06:44 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
IfixitBIG-- FYI: You can get rid of those little green triangles on your tickets by disabling Error Checking. Excel thinks that there might be a problem in the cell (even though there isn't). I believe the feature is disabled in Excel 2002 by going to Tools/Options and selecting the Error Checking tab.... then deselect the box that says something like "Enable background error checking." Sorry... I don't remember if that's it exactly. I've got Excel 2000 here at home. Alternatively, you can hover your mouse over the individual cells and a pop-up will ask you if you want to fix the cell.... and you can tell it to pound sand... or something to that effect. :-)

(Maybe others can correct me here, if I didn't get those directions quite right... )
MikeWh is offline  
Sponsored Links
Advertisement
 
post #182 of 449 Old 01-26-2005, 06:52 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Rotoman-- question:
I noticed that you posted a .bmp of your ticket. Did you know there is a button for automatically saving your ticket as a .gif? It says "Save Ticket 1 as a GIF." It should save it as "Ticket1.gif" in the directory where you have saved the TicketMaker .xls workbook.

(Just a helpful hint.... since gifs and jpgs are generally more browser-friendly when posting images in the forum.)
MikeWh is offline  
post #183 of 449 Old 01-26-2005, 07:20 PM
Senior Member
 
IfixitBIG's Avatar
 
Join Date: Jun 2002
Location: Simpsonville, SC
Posts: 275
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 22
Thanks for the information. I have them when I save as a graphic, but not on the print out.

John Burton

IfixitBIG is offline  
post #184 of 449 Old 01-27-2005, 07:47 AM
Advanced Member
 
Rotoman's Avatar
 
Join Date: Jan 2004
Location: Bismarck, ND
Posts: 829
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 40
Mike-
Thanks for the tip. I'm not printing these as I don't have a good printer so the format I'm saving them in hasn't been that important to me as I'm just emailing them out. That said, I had just cut and pasted the ticket from your program into Paint in order to add some other graphics which after reading Ifixit's posts I realized I didn't need to do. Then when I saved from paint it defaulted to a .bmp file.

Going forward, I'm just going to use the add image function in Excel to tweak the graphic. And I'll remember to save as a .gif.

To your point about the 'Save ticket 1 as a .gif' button, I don't use it as I like to keep copies of all of the tickets I make. May be a suggestion for later to have the option to "Save as" and then pick a filename. Otherwise, each time you use the program to create a ticket you're overwriting previous work. May not be a big deal to some but I like to have the old ones.

Xbox handle: TheRotoman
Rotoman is offline  
post #185 of 449 Old 01-27-2005, 08:48 AM
AVS Special Member
 
rdwalt's Avatar
 
Join Date: Jul 2003
Location: Kennesaw, GA
Posts: 1,086
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 11
Mike, Thanks for the 'disable error checking' tip. You got it right. Here's my new SBXXXIX Ticket. (All Excel, no photoshop)
LL

"If you never did, you should. These things are fun and fun is good."- Dr. Seuss
rdwalt is offline  
post #186 of 449 Old 01-28-2005, 09:15 AM
Member
 
salreus's Avatar
 
Join Date: Jan 2004
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Ok. this is what I tossed together. I am done messing with it now. This is a great program.
LL
salreus is offline  
post #187 of 449 Old 01-28-2005, 10:28 AM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Quote:
To your point about the 'Save ticket 1 as a .gif' button, I don't use it as I like to keep copies of all of the tickets I make. May be a suggestion for later to have the option to "Save as" and then pick a filename. Otherwise, each time you use the program to create a ticket you're overwriting previous work.

I had considered doing the Save As..., but thought this would be more user-friendly.... maybe not though. I didn't think people would be keeping their tickets, so I went the other way (plus the coding was easier). As an alternative, you can always rename the Ticket1.gif after it's saved, so you don't overwrite it next time. I've added this to my "issues log" for the next version.

Quote:
Thanks for the 'disable error checking' tip. You got it right.

Good to know. Thanks for the follow-up. FWIW-- this issue was raised in a previous thread about the Ticket Maker, but I can't seem to find that thread. DOH!
MikeWh is offline  
post #188 of 449 Old 01-28-2005, 11:04 AM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Finally made my last ticket. If anybody wants some of the graphics I used, like the helmets, logos, etc just let me know. I can attach them here. Thanks for everybody's great ideas!
LL
voltes is offline  
post #189 of 449 Old 01-28-2005, 11:34 AM
Member
 
salreus's Avatar
 
Join Date: Jan 2004
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
man, i looked all over the place for the DD sign. I want that for later if you want to post it. Here is another pic I ran across but didn't use.
LL
salreus is offline  
post #190 of 449 Old 01-28-2005, 11:36 AM
Member
 
salreus's Avatar
 
Join Date: Jan 2004
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
duh, I can see why now. wrong bowl. hehe
salreus is offline  
post #191 of 449 Old 01-28-2005, 11:36 AM
Member
 
salreus's Avatar
 
Join Date: Jan 2004
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
duh, I can see why now. wrong bowl. hehe
salreus is offline  
post #192 of 449 Old 01-28-2005, 11:44 AM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
salreus, is this what you want?
LL
voltes is offline  
post #193 of 449 Old 01-28-2005, 11:48 AM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
And here's a big Superbowl XXXIX logo.
LL
voltes is offline  
post #194 of 449 Old 01-28-2005, 12:19 PM
AVS Special Member
 
taxman48's Avatar
 
Join Date: Jan 2003
Location: Long Island, NY
Posts: 2,460
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 14 Post(s)
Liked: 58
Voltes: can you attach the helmet logos? How do you bring them into the ticket maker? thanks matt

taxman48 is online now  
post #195 of 449 Old 01-28-2005, 01:15 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
here's the helmet logos.
I will just attach the others in case anybody's interested.
LL
voltes is offline  
post #196 of 449 Old 01-28-2005, 01:16 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Pats helmet..
LL
voltes is offline  
post #197 of 449 Old 01-28-2005, 01:21 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
afc logo
LL
voltes is offline  
post #198 of 449 Old 01-28-2005, 01:23 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
nfc logo. very small, maybe you can find a bigger one. so far this is the only thing i can find.
LL
voltes is offline  
post #199 of 449 Old 01-28-2005, 01:24 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
eagles logo
LL
voltes is offline  
post #200 of 449 Old 01-28-2005, 01:34 PM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
pats logo

I think that's all of it. I hope somebody find them useful.

matt,

do an insert of a picture from file. insert the file and resize it to overlay the part where the you want the pics to show.
LL
voltes is offline  
post #201 of 449 Old 01-29-2005, 08:50 PM
Member
 
salreus's Avatar
 
Join Date: Jan 2004
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
yeah, that was the gif I wanted. thanks. I can use that for my normal tickets. Thanks for finding it and posting it.
salreus is offline  
post #202 of 449 Old 01-30-2005, 07:31 PM
Member
 
murph3699's Avatar
 
Join Date: Oct 2003
Location: Massachusetts
Posts: 173
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
I made a ticket of my own as well. Thanks Voltes for the logos and the Photoshop template.
LL
murph3699 is offline  
post #203 of 449 Old 01-31-2005, 01:30 AM
Member
 
ithrill's Avatar
 
Join Date: Aug 2004
Posts: 18
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
my first ticket how can i easily put a picture in the backround? (star wars ticket on page 7)
LL
ithrill is offline  
post #204 of 449 Old 01-31-2005, 07:26 AM
Senior Member
 
voltes's Avatar
 
Join Date: Aug 2004
Location: New Jersey
Posts: 216
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Quote:


Originally posted by murph3699
Thanks Voltes for the logos and the Photoshop template. [/b]

Greats tickets everyone! One more week and we can put them to good use.

Btw, I didn't provide for the photoshop template it was generously provided by bugman72.

The picture background can be done if you use the photoshop version. I haven't found a way to do that in the excel version yet.
voltes is offline  
post #205 of 449 Old 01-31-2005, 08:07 AM
AVS Special Member
 
rdwalt's Avatar
 
Join Date: Jul 2003
Location: Kennesaw, GA
Posts: 1,086
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 11
Murph, I like the 'No Recording Devices' and 'No Smoking' on your ticket.

"If you never did, you should. These things are fun and fun is good."- Dr. Seuss
rdwalt is offline  
post #206 of 449 Old 01-31-2005, 03:37 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Quote:


how can i easily put a picture in the backround? (star wars ticket on page 7)

Unfortunately, you can't do backgrounds with the Ticket Maker. I'll have to check if Excel 2003 is any friendlier with background images (possibly for the next version), but it can't be done with Excel 2000 and earlier. The tickets with backgrounds are done using a Photoshop template (also available in this thread).
MikeWh is offline  
post #207 of 449 Old 01-31-2005, 03:53 PM
Member
 
ithrill's Avatar
 
Join Date: Aug 2004
Posts: 18
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
sucks for me i guess. I don't know how to use photoshop Does someone have a tut. on inserting the pic?
ithrill is offline  
post #208 of 449 Old 01-31-2005, 05:03 PM
Advanced Member
 
704set's Avatar
 
Join Date: Mar 2001
Posts: 725
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
This thread shows why this is the best forum. Great talent and resources on every aspect. Several years ago I was trying to figure out what the hell was 5.1. Now I'm trying to figure out how to print tix for my soon to be completed theater.

Thak you.
Skip
704set is offline  
post #209 of 449 Old 01-31-2005, 07:40 PM
Member
 
murph3699's Avatar
 
Join Date: Oct 2003
Location: Massachusetts
Posts: 173
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
I sent out a bunch of "tickets" to my friends and family who will be watching the game at my house.
murph3699 is offline  
post #210 of 449 Old 02-01-2005, 03:19 PM
Member
 
murph3699's Avatar
 
Join Date: Oct 2003
Location: Massachusetts
Posts: 173
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
I added a Lombardi Trophy to the ticket I made for my pal. Here it is.
LL
murph3699 is offline  
Reply Theater Room Items & Accessories

User Tag List

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off