sunilmulay
10-30-2008, 05:59 PM
Hi there
I have the following code in my spreadsheet
Option Explicit
Private Sub Workbook_Open()
'Turn off screen updates
Application.ScreenUpdating = False
'Activate cell A1 on the Dashboard sheet at startup
With Worksheets("PP")
.Activate
.Range("D5").Select
End With
'Restore screen updates
Application.ScreenUpdating = True
End Sub
What I found when opening this spreadsheet up in Excel 2007 is that because it doesn't prompt you to Enable macros like version 2003 does, it does not automatically execute the command. ONce you are in the file, if you enable macros it doesn't run the above script automatically.
How can I get around this problem?
ThanksSunil
I have the following code in my spreadsheet
Option Explicit
Private Sub Workbook_Open()
'Turn off screen updates
Application.ScreenUpdating = False
'Activate cell A1 on the Dashboard sheet at startup
With Worksheets("PP")
.Activate
.Range("D5").Select
End With
'Restore screen updates
Application.ScreenUpdating = True
End Sub
What I found when opening this spreadsheet up in Excel 2007 is that because it doesn't prompt you to Enable macros like version 2003 does, it does not automatically execute the command. ONce you are in the file, if you enable macros it doesn't run the above script automatically.
How can I get around this problem?
ThanksSunil