MACRO HELP! Change Every Cell that contains a formula

TheRogue!

Board Regular
Joined
Mar 2, 2012
Messages
81
I'm looking for a macro (that I could have execute upon opening the file) that would find every formula in the workbook, change the formula to ="I QUIT!!!" & then save the file.
 

Some videos you may like

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,)

Joe21

New Member
Joined
Oct 7, 2014
Messages
3
the same question ...
I hope there is help
 

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,091
I'm looking for a macro (that I could have execute upon opening the file) that would find every formula in the workbook, change the formula to ="I QUIT!!!" & then save the file.

I thought going postal was one way of getting even with your employer, never thought about creating a macro to mess up their spreadsheets ;)
 

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
Destroying intellectual property may be crime for which you could be prosecuted...?

H
 

TheRogue!

Board Regular
Joined
Mar 2, 2012
Messages
81
No, no. Not looking to anything illegal (or unethical). Just want to create an example of how macros can effect internal security for use in a presentation.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,989
Members
409,553
Latest member
alscno

This Week's Hot Topics

Top