Recorded Macro

[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!!!

 

[Township of East Hanover]

I'm assuming that you are trying to assign this macro to a button! Your
posting doesn't say.

Right click your button and click view code, between the two lines that
appear enter:

PrintSummary

This is telling the button the when it is pressed it should call the sub
that you recorded.

 

[Guest]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[baston]

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

 

[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

 

[baston]

All of my other macros work properly.

 

[AlfD]

Hi!

Is there anything in your ThisWorkbook page?

Al

 

[baston]

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