Sharing a Excel spreadsheet with macros

[Bernardg]

I designed a small application that provides charts to be reviewed by 6-10 other users over the internet. The data is updated by me and the charts are generated by me after each update. I want the users to be able to read the charts but not to see the macros. Since there are 24 charts, I have to provide choices to the users to select the charts that they want to see through VBA userforms.

I looked at Sharepoint but it does allow to run macros. Can anyone advise me on the use of Skydrive for such an application?

Is there a way to generate the charts and to create userforms to control access to the charts and to have everything available through a website without having a shared Excel module?

Are there any other choices?

I am pretty comfortable with Excel for a single application but I am lost regarding sharing the output with others over the internet. Your inputs would be appreciated.

 

[JLGWhiz]

I designed a small application that provides charts to be reviewed by 6-10 other users over the internet. The data is updated by me and the charts are generated by me after each update. I want the users to be able to read the charts but not to see the macros. Since there are 24 charts, I have to provide choices to the users to select the charts that they want to see through VBA userforms.

I looked at Sharepoint but it does allow to run macros. Can anyone advise me on the use of Skydrive for such an application?

Is there a way to generate the charts and to create userforms to control access to the charts and to have everything available through a website without having a shared Excel module?

Are there any other choices?

I am pretty comfortable with Excel for a single application but I am lost regarding sharing the output with others over the internet. Your inputs would be appreciated.

You might try copying the charts to Power Point and sending those to the other users. I used to do that back when, but I no longer have code for doing the copying.