Macro for Printing/ Preview in VBA

[mars07]

Hi once again. On the verge of ending this project and you guys have been awesome in helping me... I hope this is the last hurdle... Ok here I go

When I hit the "Show DataBase" button, I want a print preview of "Supplier Database" in excel.

What I did was, record a macro, and simply call in that button. When I hit the button, it shows the preview, but the problem is somehow, the program gets into some loop... I cannot break it or stop it... I have to use CRTL+ALT+DEL method to close entire excel to break the loop...

Any Idea whats happening and how it can be stopped ?

 

[mars07]

finally it worked... thanks alot... I never thought from that perspective that I should have unloaded the account