Software

Ask something
Discussion Locked

Multiple Excel macro users

0 helpful
1 reply

by mindyeic

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Everyone in my department uses the same macros. But, we've been having a problem in that Excel stores macros under the Personal macro workbook on each person's PC. We would like to share our macros without having to open a special file to do so - we'd like to have the macros listed under the regular macro menu. Does anyone have any suggestions? We'd like something similar to what we can do in Word...

1 reply

by dklippert

You don't have to save the macros in the Personal.xls. You can save the macros in an individual work book.
You can then go to Tools>Options and point to an Alternate startup location on the network. Try saving the "Macro" work book as read-only andhidden workbook.

This discussion is closed to new replies.