When I click "File" then "New", a box containing several icons appears. How can I get an empty workbook to open when I click "New" (instead of having...

Hi, It seems I can't open a spreadsheet by double clicking the icon for it from within a given folder. When I do try to open something from the desktop it just...

Sub sheets_list() Dim a As Long Dim s As Long Dim shtName As String s = 4 For a = 1 To Sheets.Count shtName = Sheets(a).Name Sheets(a).Hyperlinks.Add...

I want to add comments to a worksheet, but not allow others to read the comments. I have seen that you can keep others from editing, but can you keep others...

My Office 2003 trial expired & now any documents I create in Office 97 (excel) can't be modified once I close & reopen the file. The file opens as 2003. Any...

I have a spreadsheet that has a huge number of worksheets that need to be deleted. I want to use a wildcard in the criteria as the sheet naming convention is...

I have saved a series of macros to use in a workbook, but Excel will not allow me to name a macro "C." I have used lots of other letters with no problem, but...

I would like to set a cells data using a formula... is this possible? For example is there a function to set cell A1 to have the value "Bob" =set(a1,"bob")

Hi there, I know to toggle between relative and absolute value references to use F4. However, I have copied and pasted a relative formula across several...

I am looking to see how I would go about creating a formula that would copy the whole row, if the value is true. So if the value of F4 is "Jim" it would copy...

I have tried clicking on File, Page Setup, Page but the print quality box is set at 600dpi and I cannot delete or change it.

I have a spreadsheet for a sales group. I want to be able to format a cell to find the biggest month of all of the salespeople. then, I want the cell next to...

I am using an Excel Invoice template. Is it possible to use my Outlook address book to enter names, addresses and shipping addresses? I'm using Office 2003

Hi, Is there a way to name (through Insert|Name or similar) a group of obgects (e.g. text boxes or images) with the same name, without grouping the...

I have created a drawing from several objects (arcs, ovals, triangles, etc.). When I try to print, some objects move (especially annoying is BlocArc)....

I have 13 spreadsheets that contain 4 weekly salary information. I have another sheet (YTD) which using absolute cell references from the other 13 sheets...

Hi, I have a table with some duplicate values in various fields. I need to extract a value from a certain row that answers to two different creterias: Name ...

Right, so this one is a biggy for me, and I'm stumped. Basically, I have to analyse the mobile phone records for my company. The invoice comes in on a disk,...