Printing Help Sheet For Addin

[Tony McGee]

Hello all

I have written a Microsoft Excel addin which does everything I want it to
do.

I have one sheet in my Addin called Help.

My addin inserts a menu into Excel & I'd like to have an option under this
menu to print out my "Help" sheet for the addin from whatever workbook is
currently loaded.

Is this possible, & if so, how?

Thanks
Tony McGee

 

[Tom Ogilvy]

assuming the code the button executes is in the addin:

Application.ScreenUpdating = False
Thisworkbook.Worksheets("Help").Copy
ActiveWorkbook.Print
ActiveWorkbook.Close SaveChanges:=False
Application.ScreenUpdating = True