View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niels Niels is offline
external usenet poster
 
Posts: 6
Default Using solver function in a locked (protected) worksheet

I have made a worksheet where I am using the solver function to optimize a
blend of products. This works perfect. Now I want to lock (protect) some
areas of the worksheet, but when doing so the solver function will not work.

Following translated message arrives:
The active document is not a worksheet, is protected or shared.

Hope someone can help me.

Best ragards,

Niels