Is there a way to change what is displayed on a hyperlink in vb code? I would like for a input box to appear and ask what name would you like to call the...

I would like to prevent any changes to an Excel 2003 spreadsheet except for the contents of cells. Is there a way to protect the formating of a worksheet, but...

I'm using Excel '03 and filling cells w/ a color (with the paint bucket). The color does not show up in my spreadsheet, but does show up when I print. Every...

When you select Window - Freeze panes at a given cell, a black line appears at the top of the cell and to the left of the cell. Is there a way to freeze panes...

Hi guys & gals. Here's what I'm trying to do. I knew the answer once, but forgot, so I'm asking for some help. Basically, I want to check to see if a cell...

Is it possible to write a conditional format like this? "If the contents of this cell do not equal the contents of the last occupied cell in this column,...

Hi, Is it possible to search for text in multiple worksheets within the one workbook in Excel 97 (I know, my company is woefully out of date!!)? I have 13...

How do I copy data from one sheet and copy it through to several sheets behind it?

I want to place some text on a template, but I only want it there to view. I don't want it to print out. I don't want to do a comment. Help?

I receive workbooks from colleagues for collation into a single workbook. When I try to copy data between workbooks, it is not pasted with the font properties...

For payroll we collect the Regular base pay from each department from a report that gives us HH:MM:SS. That number can reach into the ten thousands of hours....

I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the...

Sorry to ask again I have a problem with populating a listbox. I want to have the listbox populate using the current worksheet ranges a1:e1000. I know how...

I have a phone list divided into many catagories: a=Div#, b=what they do, c=Contact info. Im trying to create a lookup feature that allows the user to look up...

Hi all, Could any please advise me how i am able to detect an existing sheetname, e.g. "CSV", if it exist then toi delete the sheet, if it doesn't then...

I have a "checklist" type worksheet where the cells are divided by visible borders. I print the entire sheet once, then need to print on the same peice of...

I Have one columm with numbers (with one or several occurrences) 34567 34567 54311 12345 54311 33321 ... and i want in other columm

I can not save my work book. I have unchecked all the read only boxes but when trying to save to disc it still says read only.. Please help Thanks Soo

I have about 25 sheets within my workbook that I would like to color code. For some reason, when I try and format the color of the sheet tabs, the 'Tab Color'...