vba project

  1. P

    Hiding/Protecting Specific Code in VBAProject

    Hey team -- Long time fan of Mr. Excel, but this is my first post and I hope that you can help me out! The code written helps me to determine if my students are sharing excel templates in order to submit less-than-honorably-produced assignments. I created some code to automatically log the...
  2. A

    Prevent Duplicate Enteries

    Hi Excel Leaders, Need help in achieving following: I got 8 columns <tbody> A B C D E F G H 1 M W 1 1 4 5 6 =concatenate(a1,b1,c1,d1,e1,f1,g1) 2 M W 1 1 4 5 6 =concatenate(a1,b1,c1,d1,e1,f1,g1) </tbody> Now I want to avoid duplicate values in Column H Please help me...
  3. J

    Workbook still in VBA Project list after workbook is closed

    Running Excel 2007 on Vista. I have a macro-enabled Excel workbook. If I close the workbook, and subsequently open up VBA, .xlsm file is still listed in the VBA project list. However, when a colleague works with the same workbook, this does not happen. I could provide lots more details...
  4. V

    ghost VBA Projects and VBA Project password window popup

    I have couple of VBA programming related question: 1) I have created spreadsheet with VBA macros and have put password protection on the VBA project. It runs fine and does what it is supposed to do but after I close the spreadsheet (the instance of Excel is still open) the VBA project associated...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top