Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros and Formulas
Hey All,
Is there a way that you could disable formulas if upon opening a file, the user selects disable macros? Thanks, Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros and Formulas
What do you mean by disable? Do you want them not to be there? Or do
you want them not to work? Or not to be visible? If the formulas are put there programatically I guess you could put code into the open event of the workbook to prevent this happening. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros and Formulas
On Oct 4, 9:36 am, anon wrote:
What do you mean by disable? Do you want them not to be there? Or do you want them not to work? Or not to be visible? If the formulas are put there programatically I guess you could put code into the open event of the workbook to prevent this happening. If your user disables macros not sure how any code would work at all, using the open event or anything else. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros and Formulas | Excel Worksheet Functions | |||
using formulas in macros | Excel Discussion (Misc queries) | |||
If/Then/Else formulas in macros | Excel Programming | |||
Macros within formulas | Excel Programming | |||
Macros/Formulas | Excel Worksheet Functions |