Hey guys,
quick question. How do i enable all macros as soon as i open up the spreadsheet without pressing the "enable all macros" button.

thanks

basically You don't,

There are a couple of ways to do this 1 is to turn your security settings to low, but this will not protect you from malicious code, the other is to get your code digitally signed or sign it yourself savbill has written a bit about this recently in a post


see here
Dave