General

how do you circle an item on an excel document
i HAVE A FORM THAT I AM USING CREATED IN EXCEL. I NEED TO CIRCLE A NUMBER PRESENTED ON THE FORM. HOW DO I CIRCLE A NUMBER ON THE FORM WITH EXCEL ... 5 Feb 2010 17:20

How do you change the preset borders on the Formating Tool bar?
There are preset borders available to use on the Formatting Tool bar and some of them have changed from standard lines to thick lines and I don't know how I did it or how to change them back? ... 5 Feb 2010 16:14

KEEP THE CELL MARKER FROM MOVING DOWN, AFTER ENTER
HOW DO I KEEP THE CELL MARKER FROM MOVING DOWN AFTER HITING ENTER? ... 5 Feb 2010 16:14

Wait statement in macro
I have a macro that runs a query against an external data source and then updates the range of a pivot table based on the number of rows and columns the query retutrns. When I run the macro in debug mode everything works fine. When I run it from the command button the range is not updated. I suspect that sin... 5 Feb 2010 16:14

need formula help
I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 i... 6 Feb 2010 06:24

Refering to a cell above another cell
I'm trying to set up a conditional format that depends on the value resulting from taking the value of a cell and subtracting value in the cell above. I assume this would be a conditional format based on a formula? Don't know where to begin. ... 5 Feb 2010 16:14

Surface Chart Legend
I have a surface chart with several bands of various color defs. Occassionally, but not always, when the source data is modified ALL bands take on a purple color. I then have to click on each line of the legend and reformat it for the intended color. I have not discovered what causes this or how to stop it f... 5 Feb 2010 13:58

Sorting in a protected sheet
I am making a utility to share with a group of friends. I am trying to lock it down and idiot-proof it so it cannot be edited or corrupted. I see in the Worksheet Protection list there are options for users to be permitted to Auto Filter and to Sort. If I protect the sheet the Auto Filter still works fine bu... 5 Feb 2010 13:58

How to add to a macro
Is it possible to add a recording to an existing macro? The only way I have been able to to so this is to create another recording and then copy the code from the addition and paste it into the first macro. It just seems there should be an easier way. Thanks, Joe M. ... 5 Feb 2010 13:58

how to disable automatic full screen mode?
Hi, I received an Workbook from a customer of mine. It is in Excel 97-2003 format, but I am using Excel 2007. They want me to modify it to suit their needs. What is driving me crazy is that anytime I click on any cell on any worksheet, the worksheet automatically goes to "Full Screen Mode" (where I do n... 5 Feb 2010 12:51