VBA Prank

msk7777

Active Member
Joined
Mar 30, 2004
Messages
280
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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

gingerafro

Active Member
Joined
Mar 23, 2005
Messages
448
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.
 

msk7777

Active Member
Joined
Mar 30, 2004
Messages
280
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,181,852
Messages
5,932,448
Members
436,839
Latest member
Mama247

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