Search results

Narayan, Sorry to trouble you, but I have changed the shapes. I've made the shapes to where they accent the boxes instead of fill them. I've named them "plugfire" for green box, and "plugmissfire" for red box. Then i've added the shapes for all 9 guns with the following name...

Thank you! It works great. Now if both were colored and I wanted to have both go back to clear with one click how would I do that with a "Reset All" button?

Correct.

Switch steps 1 and 2.

I would like a 3rd click to be able to make the shapes green. Also I would like to have a separate button that would return everything back to normal. Can you help with this?

I really like the holiday the holiday sale trick from last month. http://chandoo.org/wp/2013/12/05/on-off-switch-in-excel-vba/ I have been looking for something like this to use in a project i've been working on. For some reason I couldn't get the button to slide when I copied code and shapes...

Thank you it worked great!! I want to add another range to the name of the newly created files. The problem is this cell is a date and shows up as 9/26/2012, well it wont work because of the character type. How can I add another cell, say "Z1", to the name and format it to be a date but in this...

No luck I was not able to get it to rename the files like I wanted it to. Here are 5 files to test and the one you sent me. I appreciate your help. https://www.dropbox.com/s/tlawrtkw7rejbnb/Test.zip

Members, I have a huge folder with alot of sales tickets from my engineers. I have a system in place now on my computer to rename the workbooks after they are emailed to me. The code I am using is below. What I want to do now is rename all of the legacy workbooks by taking the data from 3...

Perfect! Works like a champ. Thanks!

Hi. I have a field ticket spreadsheet with 6 possible pages to print. There will always be a page 1 of the ticket and could possibly be up to 6 pages. I have cells on all 6 pages that say "page 1 of (blank)" where page 1 of would be cell K6 of each sheet and (blank) would be M6 of each sheet...

Awesome! Works like a champ! Thanks you sooo much for your help.

I got it to make the save as dialog come up with the correct name. I am also able to select a different folder and click save. Then I get a runtime error '13'. When I click debug the yellow error points to the line: If Namefile = False Then I'm I doing something wrong? I'll try to attach my...

Thanks you!! That worked perfectly. Instead of saving it to a certain folder can it be coded where the saveas dialog box comes up with the dim namefile string already there then allowing the user to select his own save location? Thanks again. I learned alot from your first code!

Hi all! I'm trying to come up with a macro to save my workbook a certain way. I have a sales invoice that has 6 worksheets and I want to create a picture on the 1st sheet and assign this macro to it. I want to save it to a folder on the desktop called tickets. I also would like it where no...