• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro button

sachar

Member
Dear All,

With reference to the attach a sample file, I have a micro button at Sheet2 to get the direct print by a single click which I am not getting. However, I am getting the print on active sheet1.

May I know what is wrong with a Sheet2 micro button?
 

Attachments

  • example file_macro.xlsm
    19.2 KB · Views: 5
Dear,

To print that is at the Sheet1, which I am trying to get the print with help of the micro button at Sheet2.
 
Maybe You haven't selected Sheet1 then You clicked [Button 1] from Sheet2.
I would be more clear
if You want to print only Sheet1
then name that sheet which You want to print.
 
Dear,

Received with thanks, with reference to the above, please find the photo shoot of Visual Basic command. May I know where I can put the “Sheet1”?

Thanks.
 

Attachments

  • visual basic file.docx
    103.2 KB · Views: 3
Are you looking for something like this?
 

Attachments

  • print sheets userform.xlsb
    32.5 KB · Views: 3
sachar
You can do just like in that previous file which worked.
In that photo, You have still Your old version of Macro2.
Replace that with 'new version' as below.
Screen Shot 2017-10-22 at 17.15.50.png
 
Back
Top