Scott: The Excel plugin from Pluggers has a command *xlSheetSetProtected* which you could use to update the workbook after it’s been created using 4D VP.
As an alternative, an Excel workbook is a handful of files bundled up in a folder. You might be able to do a diff on a protected workbook vs one that is not protected and then write some code to change the value. It most likely that you can’t change the value to not-protected but you *might* be able to get away with changing the value to protected. -- Douglas von Roeder 949-910-4084 On Mon, Jan 27, 2020 at 4:52 PM Scott Staley via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The subject pretty much says it all. Anyone know how to tell View Pro to > programmatically protect a sheet. > > fyi... I basically have an excel template that I import into View Pro and > then populate with data and save it back as an excel file. The excel file > is then given to others that populate other parts of the sheet. I would > like to turn the sheet protection on so that the data populated by 4D and > any other protected cells are not accidentally modified. If I protect the > sheet in excel, than I can't use 4D to populate the protected cells. I > generate several hundred files so I don't want to do it manually. > > I'm using 4D v17 R6 > > Thanks in advance for any suggestions... > > > > -- > Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
