excel macro

Hi, I have a shared excel. Could you please provide me macro to make each worksheet password protected ? Kindly note that I require separate password for each worksheet and many users open that excel at one time. Many Thanks, shaikhstonevilla

I hope explain myself clearly first time. I have inherited a macro over 3000 lines long with 17 sub routines in it. I have a small scale project to understand how it works. At the moment I am working through hitting F8 repeatedly, until I get to a clear loop where I am putting a Stop and then...

Hi, Thank you for reading this thread. I need your help creating a macro. I have two excel spreadsheets. .i.e 1) Pivot table 2) Reports. (Report file is shared). The data in the both spreadsheets is as under. Column A) Client names Column B) Outstanding balance. I want to create a macro...

Good Morning, I need some help from you guys creating a macro in excel/outlook. My excel spreadsheet contains details as under. Column A : Client names Column B : Outstanding Amount Column C : Due Date I want to create a macro which can perform as under. 1) Macro should take Client names...

Hi Guys, I am running macro which prepares report for me from excel and save file it in csv format at the specific path. Now my problem is that while saving the file, it give me pop up "xyz file named already exist. Do you want to replace it ?" Surprisinlgy, no any file exist with the xyz file...

Hello everyone, I have a macro set up that asks for a beginning date and an ending date, then scans columns J-Y for a date that falls within that range. If the macro finds a valid date, it copies and pastes the cell containing the date and the cell directly to the right of it onto another sheet...

Many thanks for reading this post. The column "H" in my excel spreadsheet contains dates. I require a macro which can delete entire rows if cell value in column H greater than today's date. Look forward to hearing from you. Regards, Xiou Lee

Hie, So basically i have created a Excel File in which random numbers are generated. In which A1 Input Value A2 Low A3High These are the input values and the result is random numbers generated between the Low and high value, B5:B13 has this formula =ROUND(RANDBETWEEN($B$2,$B$3),-1). and B15 has...

Sub Button3_Click() Range("B19", "B22").Copy Sheet4.Range("B" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues Sheet4.Select Application.CutCopyMode = False End Sub I need only to copy the value of B19 and B22 on "Sheet4" B & C Cells respectively but when I use the above formula, it copies...

I need a macro that deletes all tabs not named "Address," "Phone Number," and "Birth Date" (there will are varying tab names depending on the report, so i want this macro to work regardless of how many and the names of the other tabs [if possible]. I would also like it if one of the above stated...

all data is in excel in A column need a vb were it search for @ in each cell and put { diameter before the email id vb or macro in a cell data is "August 5,2004" 06:16:00 PM tonytruex klblessed@hotmail com Chris Green rt 2 box 67 Fort Polk ga 94137 (310)639-4841 ("408,1263-3208 Anytime...

Hi, I'm a novice when it comes to Macros, and I want to be able to use a Macro to create random product SKUs in Excel spreadsheet format - any help would be appreciated. Thanks!

Does anyone know why this does not work? I want to set i and x as values that are entered into a cell. I then want to use i and x in the formula for calculating another cell. If anyone knows anything it will help out a bunch, thank you. Dim i As Integer Dim x As Integer i = Range(Y8).Value x...

hi i am looking to convert numbers to words need vb or macro output in the below formate <tbody> <tbody> Instructions On How To Enter The ANNUAL INCOME (In Words) $50,000 Fifty Thousand Dollars Only $50,250 Fifty Thousand, Two Hundr ed And Fifty Dollars Only $100,000 One Hundred...

Hi, I created a macro that copies a new tab into a new file and completes this new file from the one that it comes and after it finishes it saves this file. When this is over, I check the file and it is not linked, but when I close it and open it again it is linked to the source file (the one...

Hi, I am looking for a macro that will do a spell check on the screen when you open print preview in excel. Thank you

I created this macro to include a Drop Down Box in a worksheet, although I think it is a bit old-fashioned. Any suggestions to make it better? Option Explicit Option Private Module '--------------------------------------------------------------------------------------- ' Module ...

Hello...I would like to find a way in Excel to create a button that will copy from a textbox in an open MS Access form into an Excel field. Lets say for arguments sake the location of the database is C:\Test\Test.accdb, the form is called TestForm1 and the textbox is named TestTextBox1 and I...

Hi there I am using Excel 2007. I have created a macro which is creating power point slides and populating them with data from excel cells. the new presentation is using a template (which is actually a power point with an empty slide). This means my excel macro is opening the template...

Hi All Can anybody assist? I am new to macros so I have very little coding knowledge. I am attempting to set up a printing macro for my workbook which has several sheets. I have been searching the forums for something that would accomplish this to no avail. I did find this Macro which...