Share workbook which includes macros??

[jrec]

Is it somehow possible to share an Excel workbook which includes VBA macros? I want to put a workbook on the internet so that different people can use it at the same time. But with sharing, marcos are not allowed...
Any tips?

 

[SkipVought]

hi jrec,

Not entirely true. Here's a snippet from help on restrictions to shared workbooks regarding macros (taken from Excel 2000)...

Macros
Write, change, view, record, or assign macros. However, you can record operations in a shared workbook into a macro stored in another workbook that isn't shared. In a shared workbook, you can run macros that were created before you shared the workbook; although if you run a macro that includes an unavailable operation, the macro stops running when it reaches the unavailable operation.

Skip,
metzgsk@voughtaircraft.com