Hello, I am in the process of creating some data entry forms in Excel through visual basic. Basically I have one of the forms setup so that the client can enter the information requested and it will automatically be placed in a spreadsheet after clicking on a button.
I am able to allow the client to view the spreadsheet after entering the data in the form to confirm the information entered is correct, be able to switch back to the original data entry form via another form that I have created, but when this secondary intermediary form is "shown", the workbook is locked and I can only see the first sheet of the workbook but cannot click on the sheet to make any changes. Is there anyway to make it so that the intermediary form and the workbook are both actionable so that the changes can be made within the workbook if needed and the intermediary form can be used to navigate back to the original data entry if the client would like to enter more data? --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 5,000 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 -~----------~----~----~----~------~----~------~--~---
