Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Buttons in Excel
Name: kelvin Oughton Date: September 30, 2004 at 02:47:17 Pacific OS: W2k CPU/Ram: P3 800 / 128 Meg
Comment:
Forgive me i'm thick when it comes to Excel. I Need some help creating a button in a spread sheet that i have, so when i click on it, it will add 1 to the number in the next cell. I.E if Number is 1 when i click button it becomes 2 etc...
Name: rayok Date: September 30, 2004 at 12:02:12 Pacific
Reply:
First create a macro that that does the calculation. Do this by TOOLS > MACRO > RECORD NEW MACRO, give it a meaningful name. Then do the keystrokes that do the calculation you want - these are being recorded as you do it (so don't forget to smile, they constitute the macro.
Then get the FORMS toolbar up and select the button - the one that looks like a VB command button.
Draw the button on the spreadsheet, when you release the button a sub form pops up allowing you to assign the macro you want to the button.
Hopefully you stored the macro in this spreadsheet, it will then be there whenever you use it.
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any background colour on it, nor should the links being seen. O...
Summary: Is there any genius out there that can help me. Is there any way to set an active button with a macro assigned to it as a backgroung in excel. ( sorry best way i can think of explaining it.) I.E. when...
0 
