I have a co-worker who uses macros that I write for him who has
recently upgraded to Win7 and now he is not able to enable the macro
to run, I think due to security settings.

This user will open the Excel file (using Excel 2007) which is located
on a sharepoint (also 2007) and will click on the command button but
gets a message that the macro cannot be run. When the Excel file is
opened it looks like a web page, that is, the full ribbon is not
visible and there is no Office icon in the upper left that he can
click and go to Excel options to try and change the security settings.

Any suggestions on what I can tell my co-worker to do to be able to
run macros?

Thanks


John Keith