macros turned off help

  • Thread starter Thread starter Richardjs60
  • Start date Start date
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
 
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...
 
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
 
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?
 
Thanks again
security was set to High
changed to med and macros started again page code is operational
thank
 
Back
Top