Hello Sir, I have created a macro in my personal workbook but when I saved it(macro enabled) in a shared path my teammates are unable to run the macro and there is no VBA found in their system. Please help me to fix this
How can a VBA macro can be protected from getting copied? I tried protecting by a strong password using project properties, but I was shocked to see videos on RU-vid teaching how to overcome such protection. Please guide if there is any other sure way out.
This link will help: www.exceltrainingvideos.com/how-to-hide-excel-vba-code-using-password/ You may have to purchase a special software like 'unviewable' if your requirement is more stringent.
SIR KINDLY SHARE ME HOW DO IN EXCEL SHEET REMOVE THE GAPS BETWEEN CELLS USING FORMULA, I HAVE HUGE NUMBERS OCCURES IN SHEET BUT SPECIFIC INTERVALS REPEATS, SO KINDLY TELL ME HOW TO GED RID FROM THIS SPACE, THIS TYPE OF DATA OCCURS IN THOUSANDS OF CALCULATION,PLEASE GUIDE VIA FORMULA TRICK,I JUST USE AND IMPLEMENT TO GET VALUES IN CELL WITHOUT EMPTY CELLS.
Sir, The file 'x' is a macro free file, but contains macro enabled content. I'm getting this error message while opening an excel file after enabling macros and disabling protected view in trust center. Before doing the two settings, i was getting another message- the file is corrupted. Help me open the excel file
Try this: Run the "Open and Repair" tool. The steps to find the "Open and Repair" tool are: Run the Microsoft Excel Click on "File". After that, click on "Open" Open the destination folder where the corrupted excel file is saved As the open dialog box appears, choose the corrupted excel file Click on the given arrow near the "Open" button and select "Open and Repair". Or, you can use Google Sheets as shown in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-T9TtNkvL-5Q.html
Hi Dinesh Can you help me with some code How to copy paste a table( in one tab I have 3 tables so, I want select one table) from one file to another file using VBA.