Hi All,

I have created a workbook, where by upto five peaple will have access to a control sheets, all other sheets will remain hidden.

The control sheets has a dozen or so commandbuttons that run macros.

My question is, Can multiple user who are using the workbook run the macros at the same time without affecting the public declarations or interfer with any other aspect, i.e., if two users click on the customer enquirey button, which calls a macro that declares the public variables, then loads a userform which the user can filter by customer details, create emails, open web browers for address directions, update contact details, produce reports, etc, each user will be able to do what ever is necessary without affecting the other,

Any information would be greatly appreciated.

Cheers
TJ