Quick and Easy Part 2
Hello,
What is the proper syntax to call a sub routine that is in the code for sheet1, from the ThisWorkbook level code? Thanks, DBAL. |
Quick and Easy Part 2
myMacro but ensure it is a public (that is, not private) sub -- HTH RP (remove nothere from the email address if mailing direct) "DBAL" wrote in message ... Hello, What is the proper syntax to call a sub routine that is in the code for sheet1, from the ThisWorkbook level code? Thanks, DBAL. |
Quick and Easy Part 2
Thanks Bob,
So it is the same then even though the 'calling' sub is at the workbook level and the 'called' sub is at the worksheet level ... just name the sub routine. But the main thing is to make sure that sub routine is public and not private. If that isn't correct please let me know. Otherwise Thanks Again. DBAL. "Bob Phillips" wrote: myMacro but ensure it is a public (that is, not private) sub -- HTH RP (remove nothere from the email address if mailing direct) "DBAL" wrote in message ... Hello, What is the proper syntax to call a sub routine that is in the code for sheet1, from the ThisWorkbook level code? Thanks, DBAL. |
Quick and Easy Part 2
No sorry, missed the sheet bit. It should be
Sheet1.myMaacro where sheet1 is the codename of the worksheet, not its Excel name. The public bit still applies. -- HTH RP (remove nothere from the email address if mailing direct) "DBAL" wrote in message ... Thanks Bob, So it is the same then even though the 'calling' sub is at the workbook level and the 'called' sub is at the worksheet level ... just name the sub routine. But the main thing is to make sure that sub routine is public and not private. If that isn't correct please let me know. Otherwise Thanks Again. DBAL. "Bob Phillips" wrote: myMacro but ensure it is a public (that is, not private) sub -- HTH RP (remove nothere from the email address if mailing direct) "DBAL" wrote in message ... Hello, What is the proper syntax to call a sub routine that is in the code for sheet1, from the ThisWorkbook level code? Thanks, DBAL. |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com