Hi,

I am trying to use macros in existing spreadsheets. They work fine if I
create a new spreeadsheet etc. But when I try to use the same macro in an
existing sheet then it doesnt work. Highlights the error.

Simple macro such as:-
ActiveSheet.ShowDataForm

Doesn't work and the debug highlights this line yellow.

Are there some sort of saftey / secuirty settings that might be in place
that are stopping these macros?

Cheers
Matt