$$Excel-Macros$$ Protection of User forms in Excel

2010-10-23 Thread hugo.ph...@gmail.com
Greetings all I wish to be able to protect just one user form in an Excel VBA project but still allow users of the workbook to create macros and write code in the module section. Is this possible. When I have added a password to the user form it protect the entire project. Any assistance would be

Re: $$Excel-Macros$$ VBA Help

2010-10-23 Thread C.G.Kumar
You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote: I'm a beginner with VBA and looking for some guidance in how to establish what I'm trying to do. Column A Column B

$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks

2010-10-23 Thread Riaz Hassan
buddy, i'm mean the file i send u is excel 2003 (i.e .xls). but still you can use it and u can convert to .xlsx as well On Oct 22, 6:57 pm, simonl simonlet...@googlemail.com wrote: So do you suggest I un-install and re-install Office? On 22 Oct, 15:20, Ashish Jain ashishj...@openexcel.com

Re: $$Excel-Macros$$ VBA Help

2010-10-23 Thread Srinivasan Ethirajalu
refer attachment On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote: I'm a beginner with VBA

Re: $$Excel-Macros$$ Finding student whose marks are improving over three consecutive tests

2010-10-23 Thread Vaaibhav
Yes this solved the case. Can you please give me your email id so that i can communicate directly? I have a long database now. On Oct 21, 6:10 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Have a look at the attached to see if it does what you need. Regards - Dave. Date: Wed, 20

Re: $$Excel-Macros$$ Finding student whose marks are improving over three consecutive tests

2010-10-23 Thread rajesh manjrekar
Vaibhav this is easy, you first filter the list, and you will be able to see whether the student is doing well or not. there is no need for a macro. Just use DATA, filter and filter on the student. Thanks Rajesh 932-304-5443, Mumbai On Thu, Oct 21, 2010 at 8:34 AM, Vaaibhav