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?


Gord Dibben

Before protecting the Excel worksheet, you can unlock the cells you want to

Format>Cells>Protection. Uncheck "locked".

Gord Dibben MS Excel MVP


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.


Gord Dibben

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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question