Macros: Strategies For Where They Live?
Per Dave Peterson:
C:\ExcelUtils\PetesUtils.xla
That was the ticket. Thanks.
One more question: does anybody have a convenient way to rename
modules?
I resorted to exporting, deleting, changing the "Name" attribute,
then re-importing. Seems like there ought tb a
right-click.props somewhere.... but I can't find it. Even
Googled an explicit reference to same, but couldn't make it work
on my version of (11) of Excel.
No big deal, I guess.... just keep a couple lines of text in my
"BoilerPlate.txt", use it to create a .txt file for a new module,
plug in the name, and import..... but still...
--
PeteCresswell
|