$$Excel-Macros$$ Re: Need a macro to automatically merge cells in the worksheet/workbook

2009-05-21 Thread Dave Bonallack
Hi, If you don't need any merged cells in your sheet, try putting these lines at the beginning of your present code: Cells.Select With Selection .MergeCells = False End With Range("A1").Select Regards - Dave. Date: Thu, 21 May 2009 23:11:30 +0530 From: prave

$$Excel-Macros$$ Re: Need a macro to automatically merge cells in the worksheet/workbook

2009-05-21 Thread Mahesh
Hi, Please share the macro u have.. Rgds, Mahender Bisht On Thu, May 21, 2009 at 11:11 PM, Praveen Khunte wrote: > Hi all > How's everyone doing? > I am novice to macro, I need a help from you guys. I hope it should be > simple.* > Present Scenario:* I have a macro which remove non-breaking s

$$Excel-Macros$$ Need a macro to automatically merge cells in the worksheet/workbook

2009-05-21 Thread Praveen Khunte
Hi all How's everyone doing? I am novice to macro, I need a help from you guys. I hope it should be simple. Present Scenario: I have a macro which remove non-breaking space from all the cells at once in the worksheet. (If anyone need, I can share the code). Usefulness of the Macro: When you co

$$Excel-Macros$$ Re: Help in Excel - How can we work in shared file while running the macro?

2009-05-21 Thread ankur kochar
Hi, Sorry for attaching the password file. Please find here attached file for help on how to work in excel with macros when it is s On Thu, May 21, 2009 at 10:02 PM, Fabio Lemos wrote: > Your file has password... please attach a file without password or send us > the password. > > 2009/5/20 ank

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-21 Thread god is gr8 i love u
HI i want to make chart on data in excel its whole month data i want to show to difference in timing so which chart will b suitable and how cn i show the whole month data in chat also in this i hv 4 columns plz help me plz mail me on another id life_is_to_ch...@yahoo.co.in Thanx On Tue, May 19, 20

$$Excel-Macros$$ Re: Protect and unprotect all sheets

2009-05-21 Thread Fabio Lemos
Option Explicit Public Sub Protege(blnProt As Boolean) Dim wstAux As Worksheet For Each wstAux In ThisWorkbook.Worksheets If blnProt Then wstAux.Protect "PASSWORD" Else wstAux.Unprotect "PASSWORD" End If Next wstAux End Sub 2009/5/21 su

$$Excel-Macros$$ Re: Help in Excel - How can we work in shared file while running the macro?

2009-05-21 Thread Fabio Lemos
Your file has password... please attach a file without password or send us the password. 2009/5/20 ankur kochar > Hi, > > I required a urgent help, I had an excel file which i want to work in > shared, but in that file I am using macro with VB codes, I want help how to > run the macro while work

$$Excel-Macros$$ Re: Protect and unprotect all sheets

2009-05-21 Thread Paul Schreiner
WITH password or WITHOUT? Depending on what options you want on the "protect", you can use: '--- Option Explicit Sub Protect_all()     Dim pw_ent, sht     pw_ent = "test"     For Each sht In ThisWorkbook.Sheets     ThisWorkbook.Sh

$$Excel-Macros$$ Protect and unprotect all sheets

2009-05-21 Thread suresh k
Hi All, Can anyone provide the vba code to protect and unprotect all sheets in excel. Thanks & regards, Suresh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Exce

$$Excel-Macros$$ Re: Help with Macros to sum data

2009-05-21 Thread ritesh paul
pls send a sample data sheet, will write the code there. Paul On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote: > Dear Friends, Can someone help me to run a macro to calculate the sum of a > cell across sheets...for Example > > Sheet 1 B2, Sheet 2 B2 and Sheet 3 B3 have some numbers...now

$$Excel-Macros$$ Re: Macro Help - Print worksheet loop as one print job

2009-05-21 Thread Dustin
I'll try that out and get back to you. For this example, creating multiple print jobs is trivial - but the actual application involved many thousands of records that will be printed, so it is a little more important to have separate print jobs if possible. On May 21, 3:45 am, Akhilesh Karna w

$$Excel-Macros$$ Re: Help for a small Macro

2009-05-21 Thread Aindril De
Note: I have used the msgbox to test the process and show the status of the cell if it is locked or not. You can remove the two lines for the msgbox , if it is not required. Regards, Andy On Thu, May 21, 2009 at 8:52 PM, Aindril De wrote: > Dear Chande, > > Sorry for the confusion. Use the follo

$$Excel-Macros$$ Re: Help for a small Macro

2009-05-21 Thread Aindril De
Dear Chande, Sorry for the confusion. Use the following code, It will work. However there is a small drawback, you have to paste it in the sheet where you want to activate it. It will not work for any other sheet. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim Txt As Stri

$$Excel-Macros$$ Re: more than 3 rules in condtional formatting

2009-05-21 Thread Fabio Lemos
It's not possible using Excel conditional format,prior to xl2007. Fabio L. Lemos cel.: 8122-1206 Em 20/05/2009, às 13:42, Balla escreveu: > > thanks for link, but i want a way out without using macros > > On May 20, 6:48 pm, Norman May wrote: >> Try the link below: >> >> http://www.mrexcel.c

$$Excel-Macros$$ Re: Help for a small Macro

2009-05-21 Thread DOLLAR CHANDE
Dear Andy, Thx a lot for your kind help, I copied the code and pasted it in the sheet...but i m unable to copy the cell content when i click one. However being a novice, pls advice me if i need to do something to make that macro run... Thx $ Chande On Thu, May 21, 2009 at 3:12 PM, Aindril De

$$Excel-Macros$$ Extracting from Hyperlink

2009-05-21 Thread Joe Foley
Hello all, I have some hyperlinks in Excel 2007 that point to an external webpage. Rather than clicking the hyperlink, copying the data, etc. I'd like to have a function/macro that would grab the contents of the webpage based on the Hyperlink and populate another cell in the spreadsheet with the

$$Excel-Macros$$ Re: Help for a small Macro

2009-05-21 Thread Aindril De
Dear Chande, Please use the following code. Sub putclp() Dim Txt As String If ActiveCell.Locked = True Then MsgBox "this cell is locked" End Else MsgBox "this cell is not locked" ActiveCell.Copy End If End Sub Please let me know if it helps. Regards, Andy On Thu, May 21, 2009 at 1:54 PM, DOLLA

$$Excel-Macros$$ Re: want a macro code

2009-05-21 Thread Saravanan Anna
Hi, See the attached file. I will help i think. Regards On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote: > Hi all! i have attached a file, there is 5 fields in the file > my requirement is, as i put city name in city field, then all the field > should fill accordingly > like as i put Mumb

$$Excel-Macros$$ Re: Macro Help - Print worksheet loop as one print job

2009-05-21 Thread Akhilesh Karna
As far as I know it will not be possible to achieve what you are trying to, by a simple macro. Other way, I can think of, is to print each invoice to a file (prn file) using the following code. Then combine all the prn files into one(using macro). Then sending the print command using shell_execute

$$Excel-Macros$$ Re: Help with Macros to sum data

2009-05-21 Thread Saravanan Anna
Hai Use the below formula in Summary Sheet B2 Cell: =Sheet1!B2+Sheet2!B2+Sheet3!B2 Regards On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote: > Dear Friends, Can someone help me to run a macro to calculate the sum of a > cell across sheets...for Example > > Sheet 1 B2, Sheet 2 B2 and Shee