Search results for query: *

That's exactly what I was looking for - thanks!

Is there a way in VBA for Excel that a worksheet can identify how it was opened? For example if I have a macro in workbook Workbook1.xls and it calls a macro in another workbook Workbook2.xls, what code/property would I write/access in a macro in Workbook2.xls that would identify that it was...

The user hits ESC which triggers the subroutine (set up in Application.Onkey) that exits data entry mode and continues executing in that sheet. If this is more helpful, here's the code for the server sheet: Sub testmacro() Run "Client1.xls!macro1" Run...

Right, but I want it to wait until the data entry mode in client1.xls exits and the rest of the macro code in that worksheet is run, before attempting to open client2.xls and run the macro in there.

Hi Skip, Yes that's what I'm doing. In each of the "client" workbooks the first thing that is done is turn on the data entry mode and then after data entry mode is done, it calls a subroutine (defined in Application.Onkey where the user can hit ESC to exit data entry mode) where the...

Hi all, I was wondering if someone could help me! I have three spreadsheets: server1.xls, client1.xls and client2.xls. The server1.xls sheet has a macro which executes a macro in the client1.xls spreadsheet and then another macro in the client2.xls spreadsheet. This is done by a...