Macro

[Guest]

How can i stop a workbook from running if i put main formulas in a macro of
the workbook so if some one disable the macros workbook won't run?
How do i write the code for Cell B6,G6:G61,J6,K6,L6.M6?

Thank Ken Calhoun

 

[Guest]

if the formulas don't exist unless the macro runs, then it shouldn't be a
problem. Of course, you would need to remove them when the workbook is
closed (and save the workbook after removing and before closing).

http://www.cpearson.com/excel/events.htm (for information on events such as
the workbook Open, BeforeSave, BeforeClose events.

Write the code to do what? saying "or Cell B6,G6:G61,J6,K6,L6.M6?" is
meainingless

if you wanted to sum B1:B5 in cell B6 your could

Range("B6").Value = Application.sum(Range("B1:B5"))
or to put in a formula
Range("B6").Formula = "=Sum(B1:B5)"

those are just examples of course. Not way to know what you actually want
to do.


All that said, trying to protect your workbook with code is usually pretty
easily defeated.