View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Keep options permanent fora given workbook

Don't use:

Insert Worksheet

Once you have set up the existing sheets, keep a spare, formatted, sheet.
If you need a new sheet, just make a copy of the spare.
--
Gary''s Student - gsnu200817


"Jean-Luc" wrote:

Hi,

I have unchecked "gridlines" and "zero values" (tools / options / view) .

But if I open a second window, these options are reset to default value.
Same problem if I make a copy of a worksheet

Please can you tell me how I could make these options permanent, for a given
workbook.

Thank you and kind regards.
--
Jean-Luc