Re: $$Excel-Macros$$ Excel formula help

try this =IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#"))) On Thu, Jul 21, 2011 at 10:54 PM, Prabhu wrote: > Hi Friends, > > In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is > replace with # and add with the previous cell which doe

Re: $$Excel-Macros$$ ***Formula for find and replace***

Hey Prabhu, try this formula =IF(ISERROR(REPLACE(A1,FIND("ABC",A1),3,"#")),A1,(REPLACE(A1,FIND("ABC",A1),3,"#"))) On Thu, Jul 21, 2011 at 8:50 PM, Prabhu wrote: > Hi Friends, > > Can you help me to know the formula for find and replace.Examble i need to > find "ABC in the A1 cell and rep

Re: $$Excel-Macros$$ Books

*Hey, Please find the below mention link for Microsoft Excel 2077 VBA Macro Programming 2009* http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm * Regards, Vikas Chauhan* On Wed, Jul 13, 2011 at 3:46 PM, jmothilal wrote: > if any one have pdf file pls send me > > J.M

Re: $$Excel-Macros$$ pls help

Hey, Find the below mention link and read it. Advance Filter Intro. On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta wrote: > hiii, > > kindly let me know what are the benifits of ADVANCE FILER

$$Excel-Macros$$ Networkday in Access

Dear Friends, How to use Networkdays Formula in Access -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan* E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_*ccess *without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•

$$Excel-Macros$$ Export Data

HI Expats, Greeting for New Day !!! I want to export data from mysql to .csv format. just want to click in command button and data save to define location.. it's very urgent so pls help me ! -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan*

Re: $$Excel-Macros$$ Entry of more than 16 characters in a cell

Hi, use single quote ' then type 16digit number '12345678912345678 On Sat, Feb 26, 2011 at 1:31 PM, Ashish Khandelwal <4everash...@gmail.com>wrote: > Hi friends, > > > When I enter a 16 digit number in a cell, the last digit become 0. How can > I enter a 16 or more digit number in a cell. > >

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Hi Puttu, if you are using Excel 2007 then use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0)," YES", " "),"") AND 2003 then =ISERROR((IF(VLOOKUP(C12,Ukey,1,0)," YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0)," YES", " ")) On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote: > Hi Experts, > > I have t

Re: $$Excel-Macros$$ Help required in excel

Hi Jitender, it's done without using vba coding just change CODE On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar wrote: > > > On 21 February 2011 10:25, anil panchal wrote: > >> please send sample file. >> >> >> On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < >> panwar.jaibeersi...@gma

Re: $$Excel-Macros$$ Shorting Problems

Hi Sudhir, please find the attachment and check it, On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar wrote: > Dear Frnd > > I have list which have many repeated names > i want short it with formula > > > thanx > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma

Re: $$Excel-Macros$$ there has to be an easier way!

please provide data in excel.. On Sat, Jan 15, 2011 at 6:25 PM, herman gold wrote: > a1 has IN, b1 has date, and c1 has time > a2 has OUT, b2 has date, and c2 has time > > > > On Jan 15, 12:49 am, Dave Bonallack wrote: > > Hi, > > You need to tell us how this data is entered. > > Is each

Re: $$Excel-Macros$$ Top poster of the Month- Dec'10 : Ashish Koul

Hi, Congratulations Ashish, and thnx for your great contribution, On Mon, Jan 3, 2011 at 2:06 PM, NOORAIN ANSARI wrote: > Congratulations Ashish, Keep it up... > > Thanks, > Noorain Ansari > > On Sun, Jan 2, 2011 at 1:07 AM, Rajasekhar Praharaju < > rajasekhar.prahar...@gmail.com> wrote: > >> Co

Re: $$Excel-Macros$$ Recovery plz

send ur file On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote: > Dear All, > > I had made a project in excel and some macro made but i had protected with > password and forget the password. > How can i recover my VBA password. > > please give me some tips to accomplish my project. > > sajid m

Re: $$Excel-Macros$$ sum duplicate value

hi use sum if function On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna wrote: > Hi Everyone. > > Can someone explain I have data in sheet 1 The columns Name and Production > . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name > and fetch the production . But I have a pro

Re: $$Excel-Macros$$ Re:

can u give me example sheet??/ On Sat, Aug 21, 2010 at 4:15 PM, Kishan Reddy, K < kishanreddy.kethire...@gmail.com> wrote: > Dear Jai, > > Select the cells that you want to hide. > > On the Format menu, click Cells, and then click the Number tab. > > In the Category list, click Custom. > > In the

Re: $$Excel-Macros$$ File Password for Excel

yes On Sat, Jul 31, 2010 at 7:24 PM, kamlesh jain wrote: > Dear Members, > > Is it possible to open a password protected excel file if password lost. > > Thanks in advance. > > -- > Regards, > Kamlesh Jain > > -- > > ---

Re: $$Excel-Macros$$ how can I control IE8 tabs from VBA?

Hi, Ctrl+T for new tab and change tab ctrl+1(for first tab),ctrl+2(second tab)ctrl+3..and Ctrl+W for closed current TAb... On Fri, Jul 9, 2010 at 5:42 PM, bruce wrote: > I have the need to work with IE8 and TABs. I have found out how to > open a new tab, but how can I control wh

$$Excel-Macros$$ AUTO MAKE WORD FILE

Dear Friends, how to auto generate .doc file using excel data.. in excel sheet cell A1 --> ID NUMBER and B1 --> DETAILS For Example * A1 B1* *ID NUMBER* * DETAILS * 1 012345AMIT KUMA

Re: $$Excel-Macros$$ HELP IN EXCEL WORK SHEET

hi, The default setting for each cell is for them to start locked. So, you first need to highlight ALL cells in the sheet, right click, choose format, go to the Protection tab and take the tick out of the Locked box. Now no cells are locked. Now you need to select the one cell you want locking.

Re: $$Excel-Macros$$ Help: powerpoint shortcut

POWERPNT On Thu, Jun 24, 2010 at 10:21 AM, janet dickson wrote: > Hi Team > > *Sorry for asking this in excel group.* > > Does any one know the Shortcut for opening a MS Powerpoint using run box > (Winkey + R) ?? > > I can open several programs in run box (winkey + R) as shown below*:* > > MS Exc

Re: $$Excel-Macros$$ VAT CHECK NUMBER FORMULA

Dear Frnd, may be this formula helping u *=IF(ABS(((MID(A5,3,1)*8+MID(A5,4,1)*7+MID(A5,5,1)*6+MID(A5,6,1)*5+MID(A5,7,1)*4+MID(A5,8,1)*3+MID(A5,9,1)*2)-97*2))=ABS((MID(A5,10,2))),"Valid","Not Valid")* On Sat, Jun 19, 2010 at 4:14 PM, NOURREDINE BELHAJ < nourredine.bel...@gmai

Re: $$Excel-Macros$$ How to display cell contects as password *****

actual data is in the cell i.e. for number as well as for > character data. > > Please suggest. > > ~ Rajesh > > On Jun 11, 9:49 pm, Vikas Chouhan wrote: > > Chk this > > > > > > > > On Fri, Jun 11, 2010 at 7:19 PM, Rajesh Bedse > wrote: >

$$Excel-Macros$$ Automatically insert name

Dear Group Member(s), I need some help with my query please it’s a urgent!!! I have a data in excel sheet two columns name and count. I want if in column name vikas and count 10 then I want automatically insert 10 time vikas Hope some one helps me. I have also attached example.xls file……

Re: $$Excel-Macros$$ Allocating in the Order

Dear Han, please send example sheet. On Thu, Jun 3, 2010 at 1:16 PM, Han wrote: > Hi Everyone, > > > > I need some help with this formula problem I'm working on, so if you > have any free time you can help me solve it would be great. > > Tab #4 on the attached spreadsheet is the closest I have

Re: $$Excel-Macros$$ Convert 2007 to 2003

hi frnd,,, http://docx-converter.com/ chk this site.. On Sat, May 29, 2010 at 11:49 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > Please suggest a software to convert an excel 2007 file to excel 2003 > version > > Alternative which is free to use :)

$$Excel-Macros$$ Consolidate Excel Sheet..........

Dear All, Viva for the Day!!! i have more than 50 excel file in a 'D' Drive Folder, i want consolidate all excel file in a one file using macro please help me it's a urgent. 1) all file header's format are same 2) data in sheet 1. please help me plss

Re: $$Excel-Macros$$ total for unique values

Muralidhar,,, Just Chk attache file. On Sat, May 22, 2010 at 7:59 PM, NRao Mynampati wrote: > Hi deepak, > advance filter use for u. > > On Sat, May 22, 2010 at 3:28 PM, Deepak Rawat wrote: > >> Hi Murali >> >> Find the attached solution. >> >> Regards

Re: $$Excel-Macros$$ Excel 2007 open password break

send your file. On Sat, May 22, 2010 at 7:19 PM, Alpesh Gajjar wrote: > Dear All, > > I have sheet which is password protected. I forget the password. > > Please suggest me how i open this file and remove the password. > Its urgent, please help. > -- > Alpesh Gajjar > ===

Re: $$Excel-Macros$$ Excel Wonders(Excel formulas)

hi, thanx On Thu, May 13, 2010 at 12:03 PM, Rajesh Nair wrote: > Hi All, > > Please find attached Excel formula book . > This may help. > > Regards, > Rajesh. Nair > > -- > > -- > Some important links for excel users

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

me also send pleasvikask...@gmail.com On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote: > Hi Excel Masters, > > Could any one have MS-Excel Bible by john walkenbach e-book. > if so could please send it to me at 06n...@gmail.com. > > > Thanks in advance, > > Nani

Re: $$Excel-Macros$$ sum/count the number of times a name has occured

two way 1) put formula =COUNTIF($A42:$A$8,"Bill") 2) Make Pivot table On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote: > Hi > > How can i sum/count the number of times a name has occured > > Example: > John > Bill > Gordon > Bill > Bill > Sara > Bill > John > > Result: > Bill = 4 times

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

hi how to use the command pls ex plane On Tue, May 11, 2010 at 6:10 PM, vikas gupta wrote: > HI ANAND > > YOU CAN USE "RTRIM" COMMAND > > REGARDS > VIKAS GUPTA > 9311334683 > > > > On Thu, May 6, 2010 at 6:15 PM, anand shivappa > wrote: > > Please help out. I got struct here. > > > > > > > > On

Re: $$Excel-Macros$$ Re: Dear Group

http://www.ebooknetworking.com/-c-21.html just chk this link On Sat, May 8, 2010 at 4:36 AM, prabhakar thakur wrote: > Kindly send book of dot net. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > On Wed, May 5, 2010 at 6:39 PM, prabhakar thakur < > prabhakarthak...@gmail.com

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

hi anand how are you AB 1 vikas kumar =right(A1,LEN(A1)-FIND(" ",A1) RESULT IS "KUMAR" On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR wrote: > Use the function RIGHT(Select the whole text in which the textor the thing > which you

Re: $$Excel-Macros$$ Urgent Help

g link > > http://priyanr.somee.com/downloads/folderprotect.zip > > and then do the steps provided by you. > > Harry > > On May 3, 10:45 am, Vikas Chouhan wrote: > > Hi, > > > > Harpreet > > > > *ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa * > >

Re: $$Excel-Macros$$ Urgent Help

Hi, Harpreet *ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa * *how to use* open notepad and paste this command *ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *and save as key.bat file name after make key.bat file make new folder in desktop and in folder put key.bat file and pro

Re: $$Excel-Macros$$ How to Copy data from different Excel files into a single Excel Sheet in appended way?

Hi, u used Data--Import External Data-Import Data -Chouse excel file On Thu, Apr 29, 2010 at 10:10 PM, Hitesh Dhare < hitesh.dh...@idea.adityabirla.com> wrote: > Hi There, > > I am looking for a Macro which copies data from different Excels's > specific sheet into new Excel by appendin

Re: $$Excel-Macros$$ Identify unique dates for employee

hi, if u went count of identify unique dates for employee .. put.. =COUNTIF(A:A,A1) On Wed, Apr 28, 2010 at 12:34 AM, Chetan wrote: > Can anyone help me on this issue > > On Apr 26, 5:13 am, Chetan wrote: > > Hi Harmeet Singh, > > > > Thanks for your reply, It works for Month criteria, But

$$Excel-Macros$$ please help me for Excel Conditional formula with example

Dear All, Please help me for excel condition formula's, pls send formula with example ...pls it's a urgent. One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_

Re: $$Excel-Macros$$ Extracting numbers from a string

eat it solved exactly what i was looking for, once again > thanks to all who suggested me. > > Regards > Ahmed Bawazir > > On Sun, Apr 25, 2010 at 8:48 PM, Vikas Chouhan wrote: > >> Hi, >> >> Dear Just Chk this formula >> >> *=MID(A1,MIN(SEARCH({0,1,2,3

Re: $$Excel-Macros$$ Extracting numbers from a string

Hi, Dear Just Chk this formula *=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),100)* On Sun, Apr 25, 2010 at 7:46 PM, Ahmedhonest wrote: > Dear Team, > > Pleasure seeing and Tons of thanks serving the members with your valuable > suggestions and ideas. > > My query is that how to e

Re: $$Excel-Macros$$ Sumproduct

Chk it,, Multiplies all the components of the two arrays and then adds the products — On Wed, Apr 21, 2010 at 10:10 AM, Jai wrote: > Dear All, Can you tell me that what is the work of sum product. > > -- > Thanks For Mail. > > -- > > -

Re: $$Excel-Macros$$ PDF EDITOR

http://www.nitropdf.com/free/hammer/index.htm On Sat, Apr 17, 2010 at 1:25 PM, Jai wrote: > > Dear All Groups Members > > > I Need In PDF Editor Can you Give me ?, This is very urgent for me. > > > > -- > Thanks For Mail. > > -- > > --

Re: $$Excel-Macros$$ PDF EDITOR

hi, dear u used www.pdfonile.com site convert pdf to word and after changes convert word to pdf On Sat, Apr 17, 2010 at 1:25 PM, Jai wrote: > > Dear All Groups Members > > > I Need In PDF Editor Can you Give me ?, This is very urgent for me. > > > > -- > Thanks For Mail. > > -- > > ---

Re: $$Excel-Macros$$ Permutations and combinations

hijust chk On Thu, Apr 15, 2010 at 12:51 AM, MD18358 wrote: > Hi All: > > I don't want the "number of Permutations" I want to see the > permutations to a calculated sum. > > For example: How many different ways can I get 20 by looking at the > number 1 through 19. > My answer should look lik

Re: $$Excel-Macros$$ Fwd: Help Required

Chk this link http://obp.math.vu.nl/edu/project-obp/VBA-intro.pdf On Tue, Apr 13, 2010 at 2:53 PM, Venkatesan c wrote: > Thank u Dilip > > Can i have any pdf with u > > > > On Tue, Apr 13, 2010 at 2:49 PM, Dilip Pandey wrote: > >> Hi Venkatesan, >> >> Up to Excel 2003, go to Tools-> Macro-> Re

Re: $$Excel-Macros$$ Wildcards with Instr FUnction

Hi Wht type Help u req in access (Query,Form.) On Mon, Apr 12, 2010 at 11:47 PM, anju wrote: > Can we use wildcards with instr function.If yes how ? > > > I also need help in MS Acsess ? Can u pls guide me to the right way > > -- > >

Re: $$Excel-Macros$$ Does anybody have games

Hi Open http://vikask008.hpage.com/ and click free games download link On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram <06n...@gmail.com> wrote: > Hi All, > > Does anybody have games in excel sheet, if so please send me. > > > Thanks, > Naniram > > -- > > --

Re: $$Excel-Macros$$ Need Passward Cracker

Hiii, Dear Run this file On Thu, Apr 8, 2010 at 6:14 PM, Jai wrote: > > Dear All, > > Can you Give me VBA Passward Cracker, > -- > Thanks For Mail. > > -- > > -- > Some important links for excel users: > 1. Follow u

Re: $$Excel-Macros$$ Re: Plz Help me urgent

hi,, dear i have one problem. how to copy and paste formula because this is array formula function.. On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey wrote: > Hi Anil, > > Attached file is solved as per your requirements. Formula is also there. > Let me know if you have any queries. > > -

Re: $$Excel-Macros$$ FILTER

Hi, Go format as table, On Wed, Apr 7, 2010 at 6:23 PM, Jai wrote: > Dear All Members. > > How can put the filter 2 times in One Excel file . > > -- > Thanks For Mail. > > -- > > -- > Some important links for excel

Re: $$Excel-Macros$$ Access 2007 Bible

Hi, Hemant Chk This link *http://ineedfile.com/access-2007-bible-free-download* On Wed, Apr 7, 2010 at 6:09 PM, Hemant K wrote: > > Hi Group, > > Any one have this book pls provide it. > > > -- > Regards > Hemant Koranne > > -- > > -

Re: $$Excel-Macros$$ Importing Text file

HI, Right Click .txt file and open with excel just try it On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote: > Dear All, > > Need ur advise... > > I got around 20 text files in a day,which had 13 to 15 columns separated by > "|" this sign. each file contains around 15 lacs or more line items. >

$$Excel-Macros$$ Help In access

> Dear All, > > > Please help me in *access* please provide access queries and how to put > queries,,, > > *and how to vlookup,concatenate in access * > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > 9911868518, >

Re: $$Excel-Macros$$ Inserting new Sheet condition based

Dear All, Please help me in *access* please provide access queries and how to put queries,,, *and how to vlookup,concatenate in access * -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess wit

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

*how to put formula,lookup in access* On Sat, Mar 27, 2010 at 4:29 PM, Deepak Rai wrote: > Hi Vikash, > > Want help you want on Access ? > > Regards, > > Deepak > > On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan wrote: > >> hi >> >>

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

hi Dear all please help in access urgent plsss -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´

Re: $$Excel-Macros$$ Help urgently required for objective

Hi Dear all, *Please help in access* it a urgent On Fri, Mar 19, 2010 at 10:45 AM, C.G.Kumar wrote: > Dear Masters, > > > File attached for your kind consideration and support.Please let me know > whether the objective from Sl No.6 onwards is possible to achieve or not. > > > Regards, > > C.G.Ku

Re: $$Excel-Macros$$ Who to remove hyperlinks

hi Dear pls open this link. *http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ * On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or formula to remove all hy

$$Excel-Macros$$ how to convert excel into .txt

Hi, if there is ten excel file in a folder, how to convert these files's into one .txt file One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Alway

$$Excel-Macros$$ How to Open Excel Correctp File..............

-- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- ---

Re: $$Excel-Macros$$ Crack Sheet Protection Password

in excel sheet (password protect) open and press alt+f11 and paste code . good luck On Mon, Mar 15, 2010 at 10:21 AM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hi Gurus, > How to use please tell me explain > > Thanks in Advance > Nandkumar > > On Mon, Mar 15, 201

Re: $$Excel-Macros$$ Need of VBA

Dear All, Pls send V.B.A e-book ..or url -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨)

$$Excel-Macros$$ how to sum currency

Dear All, > > (i am using 2003 office) > > > if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one > column (a1:a10) how i get the sum doller, rupees or more currency in > different column > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask.

Re: $$Excel-Macros$$ RE: PROTECTED SHEET

Dear All, (i am using 2003 office) if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one column (a1:a10) how i get the sum doller, rupees or more currency in different column -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@

Re: $$Excel-Macros$$ RE: PROTECTED SHEET

2003 On Wed, Mar 3, 2010 at 7:06 PM, ankur wrote: > which version of excel you are using? > > On 03/03/2010, Chieu Ang wrote: > > Dear all, > > > > > > > > Anyone can help: How to unprotect the sheet( that has password)? > > > > > > > > Thanks > > > > > > > > Chieu Ang, Tan > > > > Finance Dep