Printing Help Sheet For Addin
 

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

Printing Help Sheet For Addin
 

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


--
Regards,
Tom Ogilvy



"Tony McGee" wrote in message
...
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