Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
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. -- Regards, Tom Ogilvy "holy41" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Thank Ken
The code work . But if i save the program they are saved in cells. So Could you help me with the clearing the cell and then savieing to the the workbook. I apperciate your help verry mutch. Thank Ken "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "holy41" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |