Make Own Print Button in Excel || Print Preview and Print Button Excel with VBA Coding
HTML-код
- Опубликовано: 3 окт 2024
- Today in this video i will teach you how to make your own Printing Button or Print Preview button in Excel with VBA Code and with Developer Tab in Excel.
VBA Code for Print Preview
👉 ActiveSheet.PrintPreview
VBA Code for Print Only
👉 ActiveWindow.SelectedSheets.PrintOut
Download Practice File Here:
➽ www.techgurupl...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉 Buy Excel Course: - TechGuruPlus.c...
👉 My Instagram: - / techguruplus
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel की सारी वीडियो यहां पर देखें
🔹 • Top 20: Advanced Excel...
(2) Tally की सारी वीडियो यहां पर देखें
🔹 • Email through Tally wi...
(3) Pivot Table की सारी वीडियो यहां पर देखें
🔹 • Pivot Table Part-1 in ...
(4) Macro की सारी वीडियो यहां पर देखें
🔹 • MACRO (PART-2) Salary ...
(5) Tally TDL की सारी वीडियो यहां पर देखें
🔹 • Download All TDL File ...
(6) Online Tricks की सारी वीडियो यहां पर देखें
🔹 • Restore Chrome Tabs Af...
(7) Sponsored की सारी वीडियो यहां पर देखें
🔹 • Edraw Max: Perfect Sof...
(8) Gadgets Review की सारी वीडियो यहां पर देखें
🔹 • MI Power Bank 10000mAH...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
My Social Media Links:
(1) Excel Expert's Facebook Group
🔴 / excelexpertgroup
(2) LinkedIn
🔴 / nazimkhaan
(3) Facebook Page
🔴 / techguruplus
(4) Twitter
🔴 / techguruplus
(5) RUclips
🔴 / techguruplusindia
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry :
✉ info@TechGuruPlus.com
✉ nazim.khan09@gmail.com
Channel Owner: Nazim Khan
🏆 Experience: 10 Years+
⏳ Website : ► www.TechGuruPlu...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#TechGuruPlus #NazimKhan
Good knowledge keep it continue
Good video Nazim bhai
how to print all records in worksheet using macro
Picture add button in sheet ?????
Sir 1 command butun me save and print dono ko add kese kare
Re please
Thank you Bhai
Sheet1 mein print button create karke sheet2 ka print lene k liye vba code kya likhu? Plz help
nice video sir
Thanks 👍👍😊
Is mein print ka range kaise set ho ga kyuin ki print commands dene se pura print ho but hamein 5 wa page print karna hai to
Very nice
Good
sir can you please make a tutorial on how to add print button to excel sheet to print specific area of worksheet. please?
Excel me invoice ki three copy original, duplicate and triplicate banaa sakte hain kya sir please video
Sir can we use record macro instead of program code...?
Excel has many commands & Formula So why we use excel vba?
Janab print k liye sirf print button hi ko desktop par kaisa rakhaen
सर यदि मुझे 3 से 10 नवंबर तक की प्रिंट निकालना है तो उसका VBA Code क्या होगा
Bahut sundar video hai.Kya aap next video in.tax form 16 (with excel formula) automated ki bana sakte hain ?
thanks
Please share coding of printing multiple sheets from main sheet button
Sir, eak video chart par par banaeye full details me..
Bhai ek macros ki series banao basic level VBA
भाई साहब सिलेक्टेड प्रिंटर्स बटन का बताओ
Sir Mai chahta hu ki Mai ek sheet pr Kam kru aur usme ek save button ho jis pr click krte hi data vha se remove ho Jaye aur dusri sheet me save ho Jaye aur next time jab Mai fir se koi data enter kru to fir se usi saved data k neeche ja kr save hota rhe
Sir
Page range kaise de print preview & print botton coding mai
Mast i need this software
👌
sir I want record macro in excel for printing for selective printer not the default printer is it possible?
Dear sir please round function bta do video me
Google sheet main kaise likhe coding wo bata do pls
It was great video, but I want to know about how can we print specified sheet with specified page with particular button
Sir ! Kia excel me ham vlookup formula shapes k oper apply kr sakte hen...?
Yani lookup value ham shap k andar bana sakte hen...?
Sir billing to bana li h. Par use update ka button kaise banana h
Excel me akhi button se pdf and print Hogan asa buttan
ये बटन गूगल शीट एप में कैसे बनाए, कृपया समझाए
Sir mery pas ya answer a raha hy (cannot run the macro "invoice _format _print_cod.xlsx!button2_click".the macro may not be available in this workbook or all macros may be disabled ab kahan se enable kerna hy please battayn
Same 2 u
Office 2007 me ban jayega kya sir...
Yes
Sir,
I have 9 Payslip in sheet 1 & all data in sheet 2 around 200 employees but when I wanted to print so I have to give command 23 times therefore I have needed VBA Code or any other tricks for if I give print command with query for printing like data connection in between word & excel Mail merge. Have any code or can you make so kindly make video on it.
Thanks
Sir I want to know how to print out in both side page by vba code , please send me links
Matsahab ek page print kana h to
सर मेरा एक सवाल है कि क्या home tab ki तर ही excel sheet par batan रेबन बन सकती हैं क्या
जिस मे मान लो exam par click kera to us मे time tebal ke sheet, results ke sheets, admit card ke sheet के batan bna पाये
यानि एक batan us me sab batan
🙏🙏🙏🙏 help and video replay kerana
Create video on new taxable income tax rate for FY 2021-22 as per New slabs ASAP with full explanation if you can.
Hello sir
Excel me kisi ko pata na chale ki ye excel file he is ke liye file menu ko hide karne ke liye VBA code chahiye.
Sir, if you get some free time, then you post a video about the power point VBA animation with the command button.
bhai CD pakistan me kese phunche ge....
Sir CD nahi hai online access hai , course Google drive par uploaded hai....
@@business-excel payment kese kro gan....
@@alatashgroup3784 you can click on this link www.techguruplus.com/professional-excel-course-in-hindi/ then click on Buy Now button on the website page..... Thanks
How to save this sheet ??? Please reply
Just go to save as then select the format .xlsm there
How to calculate Days Remaining? Days Remaining Ki puri process kesi hoti he ?
Maine bahut try kiya pr Days Remaining mera exactly hua nai
Sir I tried this and found error (Sub or Function not defined) give me solution
Why don't you teach it in English?