Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lotus notes export to excel document
My Lotus notes form populates a number of cells in an excel form, however
there are other cells in excel that should not changed. My idea was to protect the document to prevent others from changing those "forbidden" cells. However, my Lotus programer informed me that since the document is protected the data from lotus is also blocked from populating the excel sheet. Is there another option to lock cells, without using PROTECT document? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lotus notes export to excel document
Before protecting the Excel worksheet, you can unlock the cells you want to
populate. FormatCellsProtection. Uncheck "locked". Gord Dibben MS Excel MVP On Mon, 9 Jun 2008 08:47:10 -0700, Steve wrote: My Lotus notes form populates a number of cells in an excel form, however there are other cells in excel that should not changed. My idea was to protect the document to prevent others from changing those "forbidden" cells. However, my Lotus programer informed me that since the document is protected the data from lotus is also blocked from populating the excel sheet. Is there another option to lock cells, without using PROTECT document? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lotus notes export to excel document
Gord-
Thanks, I designed the spreadsheet to lock the cells that populate from Lotus. The other cells that I want my users to populate are unlocked -but appearently this won't work?!?!?! I don't know if this is a LOTUS or an EXCEL limitation, but my programmer is NOT an excel expert. Thanks Steve "Gord Dibben" wrote: Before protecting the Excel worksheet, you can unlock the cells you want to populate. FormatCellsProtection. Uncheck "locked". Gord Dibben MS Excel MVP On Mon, 9 Jun 2008 08:47:10 -0700, Steve wrote: My Lotus notes form populates a number of cells in an excel form, however there are other cells in excel that should not changed. My idea was to protect the document to prevent others from changing those "forbidden" cells. However, my Lotus programer informed me that since the document is protected the data from lotus is also blocked from populating the excel sheet. Is there another option to lock cells, without using PROTECT document? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lotus notes export to excel document
With the sheet unprotected but cells set to locked and unlocked as appropriate.
Record a macro whilst importing the data. After getting the code for the importing add a couple of lines at beginning and end to unprotect the sheet then re-protect at end. Sub import() Sheets("Sheet1").Unprotect Password:="password" your import code Sheets("Sheet1").Protect Password:="password" End Sub If users disable macros, this will be defeated. Gord On Tue, 10 Jun 2008 06:45:00 -0700, Steve wrote: Gord- Thanks, I designed the spreadsheet to lock the cells that populate from Lotus. The other cells that I want my users to populate are unlocked -but appearently this won't work?!?!?! I don't know if this is a LOTUS or an EXCEL limitation, but my programmer is NOT an excel expert. Thanks Steve "Gord Dibben" wrote: Before protecting the Excel worksheet, you can unlock the cells you want to populate. FormatCellsProtection. Uncheck "locked". Gord Dibben MS Excel MVP On Mon, 9 Jun 2008 08:47:10 -0700, Steve wrote: My Lotus notes form populates a number of cells in an excel form, however there are other cells in excel that should not changed. My idea was to protect the document to prevent others from changing those "forbidden" cells. However, my Lotus programer informed me that since the document is protected the data from lotus is also blocked from populating the excel sheet. Is there another option to lock cells, without using PROTECT document? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Has anyone sent emails from Excel via Lotus Notes? | Excel Discussion (Misc queries) | |||
?? Email Excel sheet thru Lotus Notes | Excel Discussion (Misc queries) | |||
Lotus Notes Doc LINK in Excel??? | Excel Discussion (Misc queries) | |||
Export Excel data to Lotus Notes 6.5 Address Book | Excel Discussion (Misc queries) | |||
How do I hyperlink from Excel to a document held in Lotus Notes? | Excel Discussion (Misc queries) |