macros turned off help

R

Richardjs60

I had a problem with refreshing a pivot table automatically. I sorted
this with a Page code Excell 2000
trouble now is I seem to have turned off macros and it won't refresh
anymore
looked up help but can't find simple "to turn macros on"
any help appreciated
thanks
 
D

Debra Dalgleish

Have you tried closing and reopening the file?
I had a problem with refreshing a pivot table automatically. I sorted
this with a Page code Excell 2000
trouble now is I seem to have turned off macros and it won't refresh
anymore
looked up help but can't find simple "to turn macros on"
Click to expand...
 
R

Richardjs60

Yes plenty of times it said that macros should open when Excel does but
this hasn't happened When it opens bottpm left corner states asking for
virus scans ! could this be stopping it?
Regards
 
D

Debra Dalgleish

Is your Excel security level set to Medium? ( Tools>Macros>Security )
Perhaps one or more settings on your virus scanner need to be changed to
allow you to open the file with macros enabled?
 
R

Richardjs60

Thanks again
security was set to High
changed to med and macros started again page code is operational
thank
 
Top