$$Excel-Macros$$ Re: Protect Cell Content on Input Result

It can be doen by writing a simple macro, wherein you will have to use two properties You will have to mention that a prticular cell in column A if it is true then select the corresponding cell in column B / C / D and then Selection.Locked=True and ActiveSheet.Protect ("Password") these two will

$$Excel-Macros$$ Re: How to unhide the sheet

Hi, Have u tried this one.?     Tools-Options-General tab-Sheets in new workbook-make changes here..     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :naveenkumarmn...@yahoo.com   Best Wishes-Karunaada Kuvara --- On Mon, 1/19/09, vin

$$Excel-Macros$$ Re: Find & Add

Here is the code to do it Cells.Find(What:="Apple", LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ActiveCell.FormulaR1C1 = " Mr. " & ActiveCell In the first line of code it asks what d

$$Excel-Macros$$ Re: Create a file that linked with excel sheet

Create hyperlink for those particular sheets. I feel it will help you out. Regards kumar On 1/19/09, VIRAL PANDYA wrote: > Plz plz plz help me out. > > > > On 1/18/09, VIRAL PANDYA wrote: >> >> Dear All, >> >> I have a excel sheet contains 128 Sheets and daily i have to take print >> out >

$$Excel-Macros$$ Re: Create a file that linked with excel sheet

If all you want to do is print a few sheets from your workbook. Try the following : Public Sub PrintSomeSheets() Dim FileName As String Application.ScreenUpdating = False FileName = "C:\Accounting\Reports\Budget.xls" Workbooks.Open FileName, , True With Workbooks(FileName)

$$Excel-Macros$$ macro that will combine workbooks

hi I have several work books having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thnks in Advance Regards Debasish --~--~-~--~~~---~--~~ Visit the blog to download Ex

$$Excel-Macros$$ macro that will combine workbooks

Hi I have several work books(excel files) having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thanks in Advance Regards Debasish -- debasish sahu IIT Bombay. --~--~-~--~~

$$Excel-Macros$$ Re: Protect Cell Content on Input Result

Yes, this is possible. What you're looking at is using the Protect Sheet functionality. Try recording a macro and Protect/unprotect a sheet. Now, are you wanting to make SURE that the user cannot modify or see the data? or just make it easier to use? If you're wanting to make SURE, then you'll hav

$$Excel-Macros$$ stop losing links from drag and drop

I have added roster.xls for further explaination I have 2 worksheets The first is for printing out the timtable for easy reading The second is for adding the schedule on teachers etc in an easy to use in line format This document would be held on a public folder, I would normally protect the fi

$$Excel-Macros$$ Re: foget password

On Mon, Jan 19, 2009 at 7:23 AM, shay shay wrote: > please mail ur file. > > On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa > wrote: > >> i protected by password on my working files but after long time when i >> try to open it , i can't please advise me how to open my files. >> >> > > > -- > S

$$Excel-Macros$$ Find & Add

Dear Group, Need ur help, pls suggest is it possible some macro or formula find some specific text from data & Add some text in before the text e.g in a lage data base i have some name containing "Kumar","Kaur","Chandra", "Kumari" if name contains Kumar then Mr. will add as prefix like Pradeep

$$Excel-Macros$$ Re: Create a file that linked with excel sheet

u can use Hyperlink to link those 5 sheets On Sun, Jan 18, 2009 at 6:31 PM, VIRAL PANDYA wrote: > Dear All, > > I have a excel sheet contains 128 Sheets and daily i have to take print out > only for 5 Sheet (record sheets). > > Is there any way by which i can create a linked excel file for onl

$$Excel-Macros$$ Re: Create a file that linked with excel sheet

Plz plz plz help me out. On 1/18/09, VIRAL PANDYA wrote: > > Dear All, > > I have a excel sheet contains 128 Sheets and daily i have to take print out > only for 5 Sheet (record sheets). > > Is there any way by which i can create a linked excel file for only this 5 > sheets? > > Please help

$$Excel-Macros$$ Re: How to unhide the sheet

its not working I tried it.. On Jan 17, 2:34 pm, "vijender kumar" wrote: > Just go to > > Fomat > sheet > unhide the sheet. > > On 1/16/09, vinu wrote: > > > > > > > hello frnds, > > > Whenever I open Excel new file(2003) I can see only sheet 1 and 3, > > sheet 2 is hidden.  I tried to unhide b

$$Excel-Macros$$ Re: how to create macro in excel which can speak the cell content...

You can use the below mentioned code. Just change the cell reference in the bracket after range where you see A1. Sub Speak_the_cell() Application.Speech.Speak (Range("A1").Value) End Sub On Mon, Jan 19, 2009 at 7:02 AM, Bakul Patel wrote: > G'day guys, > > I am trying to get a macro in ex

$$Excel-Macros$$ Protect Cell Content on Input Result

Hi all! I'm looking to protect a number of cells, or, make them 'read only' if you like dependant on the result of the inpurt from a certain cell. The spreadsheet I'm composing is to be sent out to a third party for input so I want to tie down some detail without making it look too daunting. To

$$Excel-Macros$$ urgently need excel spreadsheet for job order costing.

*Dear all* * * *I urgently need excel spreadsheet for job order costing.* *Will anybody provide me?* * * *Thank you all in anticipation* --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this g

$$Excel-Macros$$ FUNCTIONS AND MACROS

Dear all, Please forward anybody have practical used excel functions and VBA programmes for Macros Thanks in anticipation. -- With Kind Regards, Suhas T S --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com