VBA error

[vasim]

The below code works well in 2007 but throws an error in 2010. The reason I believe is 2010 don't provide the option for "Enable Macro" and stores it in trusted places.


Whats the alternative for this...


In workbook


Private Sub Workbook_Open()

Application.ScreenUpdating = False

Sheet1.Range("A1:Q30").Select 'ERROR MESSAGE POPS UP

ActiveWindow.Zoom = True

[B10].Select

Application.ScreenUpdating = True

End Sub

 

[sdsurzh]

Hi,


Can you please refer the below link.


http://www.addictivetips.com/windows-tips/enable-all-macros-in-excel-2010/


Thanks,

Suresh Kumar S