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.

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.

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.

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.