Printing Help Sheet For Addin

T

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying help for an addin 3
Microsoft Excel Addin 2
Copy a Sheet to an AddIn 2
Addin Modified date/time 2
EXcel Functions in VBA 5
addin menu button xl2007 2
Addin close command not working in new workbook 3
Editing Code from Code 1

Top