VBA Prank

I thank everyone for their concern, but this is one of my creations and if it gets messed up I am the one that has to fix it. Plus I am trying it out on a copy of one to see what happens.

erik.van.geit:

I did read what you wrote me, and I only did the code for what I originally asked for, didn't want to try to much out at once. I created a new module and copied your code into it, clicked save and then exited out and re-opened it. There are other modules already in there and was wondering if they may be interfering? If so then I will just leave this alone.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
I put the code into a module, saved and closed out of the workbook opened it back up and made some changes to the workbook and nothing happened? Did I maybe miss something?

Now THATS a prank.
 
I got it to work, thanks everyone, I will keep reading into what you sent me, that is a lot to read and practice and learn. Thanks!
 

Forum statistics

Threads
1,214,515
Messages
6,119,973
Members
448,933
Latest member
Bluedbw

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
Back
Top