Re: $$Excel-Macros$$ formatting text box

see if it help On Sat, Apr 16, 2011 at 4:55 PM, Dick wrote: > I have a text box with the following code. But I'm finding it > difficult for some people to input the correct time by following the > format. Is it possible to have the text box with 3 different entries > such as 0/0/0 or 0:0:0. So t

Re: $$Excel-Macros$$ How to make excel addins

try this http://www.ozgrid.com/VBA/excel-add-in-create.htm or once you will save file as xlam in excel 2007 goto excel option goto addins-> bottom you will find manage option choose excel addin and in browse slelect your addin and ok. and now in macro type your macroname(which will not be visi

Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

try this Sub method2() Dim i, j, k, s As Long s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) For i = 1 To s Sheets(i).Select 'change upper row here in this case it will start copying from second row j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count

Re: $$Excel-Macros$$ How to make excel addins

Hi, Ok i have saved as Add In file on my add In folder, But now how to run the Add in file. It may be a basic question but really i don't know how to run the Add in file. Plz help. Prabhu -- -- Some important li

$$Excel-Macros$$ formatting text box

I have a text box with the following code. But I'm finding it difficult for some people to input the correct time by following the format. Is it possible to have the text box with 3 different entries such as 0/0/0 or 0:0:0. So the curser is set to start at the hour, then automatically tab to the mi

$$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

Hi Experts, Please provide me the solution for this. Regards Gohil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linked

$$Excel-Macros$$ Re: Open Excel addin is unavailable

Dear Adhish, Thank u very much. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

$$Excel-Macros$$ Re: Open Excel addin is unavailable

Dear Ashish, Thank u very much. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

Hi ashish, Is there any way to keep common code for all sheet? Because i may have to use this code on various sheet on many time. On Sat, Apr 16, 2011 at 11:35 AM, ashish koul wrote: > change > > Sheets(1) > > as per your requirement > > activesheet or Sheets(" name of sheet") > > > > On Fri

Re: $$Excel-Macros$$ Please make for me in macro code for in attached

Dear Please use Pivot Table Regards On Fri, Apr 15, 2011 at 12:50 PM, Umed Singh wrote: > Hi Dear, > > I need your help in attached file. Please make for me in macro code > for in attached file. > > i want to selected department and past another sheet for seperately. > > -- > > -

Re: $$Excel-Macros$$ Re: Password protect & unprotect sheets using code

Hi Thank u very much. Regards Rajesh kainikkara On 4/15/11, JsinSk wrote: > I pulled your answer from URL listed below, second and third post both > give different approaches depending on your needs. Below protects and > unprotects all sheets, if you just need one sheet there are other > optio

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Hi, Thanks for ur reply Regards Rajesh Kainikkara On 4/15/11, STDEV(i) wrote: > Sub ABCD() > Sheets("MySheet").Unprotect "yourpassword" > --- your program accessing to sheets("MySheet") > Sheets("MySheet").Protect "yourpassword" > End sub > > > On Fri, Apr 15, 2011 at 6:51 PM, Rajesh K R > wr