Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

2009-12-14 Thread Dilip Pandey
Dear Vinod, By line Remeber some software do not ask for serial keys. :) - I meant to say that there are some softwares which do not asks for serial key(s) as they don't have the relavant option to enter serial key. So these types of softwares are only be cracked / patched. Alternatively, you

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

2009-12-14 Thread Dilip Pandey
Thanks Mr. Shah..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Dec 13, 2009 at 11:27 PM, harsh shah harshsha...@gmail.com wrote: hey this was good one 2009/12/13 Dilip

RE: $$Excel-Macros$$ Re: Rota planning

2009-12-14 Thread Dave Bonallack
Just attach it as you would any attachment. Dave. Date: Sun, 13 Dec 2009 23:16:49 -0800 Subject: $$Excel-Macros$$ Re: Rota planning From: j...@jpwebs.co.uk To: excel-macros@googlegroups.com Sheet did not attach - where do I do this please? John --

$$Excel-Macros$$ Re: Rota planning

2009-12-14 Thread Paul
When you first go to the Google Groups page for this group, there is a files- area: http://groups.google.com/group/excel-macros?hl=en and a button to add afile. On Dec 14, 2:16 am, Tonto j...@jpwebs.co.uk wrote: Sheet did not attach - where do I do this please? John --

Re: $$Excel-Macros$$ Alert for repeating cell information

2009-12-14 Thread ChrisInHolland
Many thanks for the responses! The two that have been provided work perfectly. I think I'll step into the shallow end from now on, not the deep end :) On Dec 11, 7:20 pm, Paul Schreiner schreiner_p...@att.net wrote: How is it that you WANT it to function? do you want it to check when you ENTER

Re: $$Excel-Macros$$ Alert for repeating cell information

2009-12-14 Thread ChrisInHolland
Many thanks for the responses! The two that have been provided work perfectly. Thanks also for the workbook, it's a brilliant starting point. I think I'll step into the shallow end from now on, not the deep end :) On Dec 12, 1:13 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Chris, You

$$Excel-Macros$$ Re: Rota planning

2009-12-14 Thread Tonto
I have now uploaded the file and would be grateful for any help. Thanks John On Dec 14, 1:31 pm, Paul schreiner_p...@att.net wrote: When you first go to the Google Groups page for this group, there is a files- area: http://groups.google.com/group/excel-macros?hl=en and a button to add

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

2009-12-14 Thread Vinod N
Anyways.. Thanks a to!! Dilipji On Mon, Dec 14, 2009 at 5:00 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinod, By line Remeber some software do not ask for serial keys. :) - I meant to say that there are some softwares which do not asks for serial key(s) as they don't

$$Excel-Macros$$ VBA code - required - Printout directly from a folder

2009-12-14 Thread Vinod N
Hi Excel Gurus, Many image files(tif)(say 200 files) will be pasted in a particular folder through fax server and i need to take printout of the same and also keep a log/list of image that has been printed. Can a code be created such that i can click a button and the files from that printer are

Re: $$Excel-Macros$$ VBA code to trace formula *

2009-12-14 Thread gurdev singh
Hi dear, If you want to see formulla in excel sheet no need of macro just put one command (CTRL + ' (APOSTROPHE) Regards, Guru On Sun, Dec 13, 2009 at 1:03 PM, Sameh Hassan Alkadry shas...@kaegypt.comwrote: Junk Score: 3 out of 10 (below your Auto Allow

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-14 Thread Abhishek Jain
Hi Punnet, I missed an important thing in this file, would sent you corrected file shortly. Regards, AJ On Mon, Dec 14, 2009 at 4:35 PM, Abhishek Jain abhishek@gmail.comwrote: Hi Punit, Please see if attached file helps you. User Password - user User working range - B2:B10 Admin

Re: $$Excel-Macros$$ VBA code - required - Printout directly from a folder

2009-12-14 Thread rf1234 rf1234
MODULE1 Option Explicit 'In input box assign the path i.e c:\tc\bin 'for more help u can contact directly at rfhyd1...@gmail.com Sub Batch_Print() Dim Input_Dir, Print_File As String Input_Dir = InputBox _ (Input directory path

Re: $$Excel-Macros$$ need help in excel

2009-12-14 Thread vinod rao
Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please not that

Re: $$Excel-Macros$$ need help in excel

2009-12-14 Thread vinod rao
This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao vinod.ma...@gmail.com wrote: Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge