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

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/groups?thre...5B41%40msn.com

Jason wrote:

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