| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
solver macros in protected worksheets
I've succesfully built a macro that run 2 solver commands in 2 separate tabs
of the same workbook. However, If I protect the worksheets with passwords, the solver macros trigger an error message - error in parameters or contraints. It works if I unprotect and then protect within the macro, but cannot use it if I really want to put a password. Any alternatives? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros, Forms, & Protected Worksheets..... how would I... | Setting up and Configuration of Excel | |||
| Macros with Protected Worksheets | Excel Discussion (Misc queries) | |||
| Group, Outline, Protected Worksheets and Protected Workbook | Excel Programming | |||
| Help please - how to run Solver in a protected sheet? | Excel Programming | |||
| Solver via VBA on protected sheet problem | Excel Programming | |||
Threaded Mode
