Default macro usage to this workbook?

[Guest]

Hi,
Just wondering if there is a way to set the default macro usage to "This
Workbook" rather than "All Open Workbooks". I'm getting some conflict with
macros in other workbooks that users are open and I don't want them to have
to go into the macro settings every time they use my workbook and select
"This Workbook".

Thanks for any help

 

[Dave Peterson]

You may be better off giving the users a nicer interface to your macros.

You can add some options to the menubar. I like the way John Walkenbach did it
in his menumaker.xls workbook.
http://j-walk.com/ss/excel/tips/tip53.htm

It's easy to update and looks really professional.

And for toolbars, I like this:
http://groups.google.com/[email protected]