I have the following situation. I have created my macros (some in module, some in individual worksheets
so that I can fire the macro with events and some in Thisworkbook so that I can control printout event)
Then I use
the custom toolbar to build a basic toolbar with all the required macros and attached it to the file so that any users can
also use the toolbar. However, this custom toolbar is set to be invisible when switch to other workbooks (set this in
Now, here comes the problem. Whenever I save the next version or even a new file name, the macros
in the custom toolbar will automatically refers to new filename macros. Hence, all those macros in the custom toolbars that
refers to macros in individual worksheets will not fire for the older file version or filename.
I need this to be
"universal" as this is the master template and users will start to save new filename and even add versions to the
same file name. It will not be a problem if they keep using the newest file but if they were to go back and use the older
version, they will have problem of not firing the events.
Lastly, I have also tried using
set abc = worksheets("def")
but there are some code that uses
selection."the required function"
and it is always at this point of time, the macro will have problem. I have also tried moving all macros out to module and
using the above to refer codes back to individual worksheets that they need to be fired upon, but alas, all failed.
Please kindly advice a way which I could use a macro to let the custom toolbar to be always using the macro within this
workbook or this filename.
Thanks in advance and sorry for the long explanation.