MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

print with macro in spreadsheet

  Asked By: Kenneth    Date: Jan 11    Category: MS Office    Views: 1805

I want to perform a task that when i click the button PRINT DIAGRAM i
will get a print copy of selected sheet (not the whole workbook)

I want to know also how to add button in worksheet

is it be done? with or without macro?



2 Answers Found

Answer #1    Answered By: Bien Nguyen     Answered On: Jan 11

Try recording a macro.
do a "quick print" of the sheet.
Stop recording.
Add the button  (using the control toolbox).
Assign the macro  to the button.
Is that what you're looking for? Do you need detailed instructions?

Answer #2    Answered By: Freddie Evans     Answered On: Jan 11

printing a hidden worksheet

I have a spreadsheet  with 4 worksheets, 3 of these are hidden. I wish to print
one of them out by having a print  button on the visible sheet. Is this possible?
The hidden sheet  I wish to print is called 'Action Plan'.

Didn't find what you were looking for? Find more on print with macro in spreadsheet Or get search suggestion and latest updates.