
07-04-2011, 04:55 PM
|
|
Newcomer
|
|
Join Date: Jul 2011
Posts: 1
|
|
Activate sheets and cells in separate workbook
|
Hi
I have two seperate workbooks in Excel - one with my command buttons and user forms, and the other to store the data entered. I need some code for a command button on the first workbook where the user forms are stored that will open the second workbook where the data is stored, activate a particular sheet within the data workbook and find the first empty row within the sheet, and then I need that sheet to be viewable to the user. I've tried all sorts of different combinations, and either the sheet isn't viewable to the user, or the sheet isn't activated properly. Help Please.
|
|