Hopefully someone has a simple solution to this.
I have setup an Excel workbook to link some variable fields from the EPDM datacard.
Everything works great - however, I of course want more...
Some of the fields on the datacard are read only and I want the same level of protection in Excel.
I have tried locking the cells and protecting the sheet in Excel, but those particular locked cells don't update with the variable information.
I have been researching and it looks like there may be a way to unprotect and protect the file via an auto open vb macro. Not sure how it would work though.
Has anyone had a similar problem and found a solution?
Figured it out - simplest solution was the best...
unlocked the cells that are linked to read only fields on the data card
then created some locked cells that have a formula equating them to the unlocked cells
hid the row of unlocked cells and protected the sheet
now the data populates correctly and no one can access the hidden cells
Retrieving data ...