good morning Paul & Paulo I like both your name.. Well sorry for confusing you.. anyway. i think you are right i need to put some vba in that worksheet where if the rows with data is 10 or more. ( yes rows 1-9 has data)
I want to limit the inputs of the user to upto 10 rows only. the worksheet should trigger message and close workbook if data is beyond row number 10. if any data is inputted beyond that, the workbook closes. On Mon, Nov 9, 2009 at 7:03 PM, PauloBR <parauj...@gmail.com> wrote: > > Good Morning Dellosa, > > How many rows and columns do you have in your sheet? > > Please, give us more information about your problem... > > Best Regards > > On 9 nov, 02:31, OSAVentures Calamba <osav...@gmail.com> wrote: > > dear gurus, > > > > i need to close a workbook if last row with data =10, Any VBA suggestion > > please? > > > > dellosa > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
