Recorded Macro

B

baston

I have a button created that has a macro assigned to it that I recorde
while using the report manager. The macro is:

Sub PrintSummary()
'
' PrintSummary Macro
' Macro recorded 4/29/2004 by aston
'

'
Application.ExecuteExcel4Macro String:="Report Manager"
Application.ExecuteExcel4Macro String:="Report Manager"
Application.ExecuteExcel4Macro String:="
REPORT.PRINT(""Summary"",1)"
End Sub

When I exit Excel and return to my workbook, my button does not d
anything.

Help!!!
 
B

baston

This worked but when I exit my workbook and Excel and re-enter, th
button does not do anything....
 
A

AlfD

Hi B Aston

Is it possible you have your security settings set so that macros ar
not even queried, let alone run, when you open a file?

Al
 
B

baston

No, there is not. Should there be? I am really green at Excel compare
to most on this forum
 
Top