Hello, I'm trying to search and replace but I do not want to replace the whole cell, only a few characters in them. Namely, I have list of names, some of which...

Hi how would I set up a column to give the average of pass to fail rate? i.e. if A1 50 then put pass in C3 else put fail then give the average of passes to...

I am trying to create an excel spreadsheet which has hyperlinks to machine names and current software and a column with hyperlinks to a batch file I have to...

I have a calendar on a user form, along with 2 textboxes. The code works thus far. The user must click in a textbox and click a date in the calendar. I...

Hi guys, If you are serious about your professional career and pass IT Certification exam in first attempt then visit http://www.beitcertified.com and get...

I have a workbook with 5 sheets. Sheet1 is Customers Sheet2 is YTD Sales 07 Sheet3 is Total Sales 06 Sheet4 is Total Sales 05 Sheet5 is Total Sales...

hi i am having the integer values in the column of h2 in sheet1 i like to have the same value in column of d56 in sheet2

Hi I have a working Excel VBA macro and would like to use a form for all the inputs. I have the form and the code behind the text/combo boxes etc. I...

Hi I have a working Excel VBA macro and would like to use a form for all the inputs. I have the form and the code behind the text/combo boxes etc. I...

i have a worksheet in a workbook i need a password so no one can view it. only the main user can view it by entering the password it contain valuble...

Is there a way to hide a row & column with a password in a worksheet, in such a way that the other user should be able to work on the same worksheet but with...

i have an old dell latitude laptop computer with xp home edition. i hardly use this computer and in doing so i forgot my password. i can't log in, is there...

How do I password protect a shared excel book so that people have read only access but so thta I can have write access?

Is there a way to Password Protect a workbook so that someone else using the computer cannot open it ? Thanks

the problem ive got is one of my explanners at work has created a document which has been password protected so as it can only be opened via read only and he...

When I open a password protected to modify sheet, the dialog box says - "filename.xls" is reserved by - followed by a blank line. How do I insert my name in...

Hi I need to unlock the VBA project in an Excel file, but I don't remember the password. I know, that there is a small script, that is searching for password...

How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003.

How do I prevent a workbook from being opened until a password is entered. I have tried the ToolsProtectionProtect SheetProtect Workbook and Protect and...

Hey Folks. Excel 2000 with service pack 3. There is a file on my company network that from what I'm told has always been password protected. All of a sudden a...