Formula Cells
Hi All
I do have an excel sheet, which contains formula. Formula cells are hidden and locked by protecting the work sheet. I need to import data from external files. If a worksheet is protected, importing or exporting data from external files is not supported. How can i lock and hide formula cells, as well as import / export data from/to external files. Thank you Regards Rema |
Formula Cells
In your code, unprotect the sheet, import the data, the protect the sheet
again. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rema" wrote in message ... Hi All I do have an excel sheet, which contains formula. Formula cells are hidden and locked by protecting the work sheet. I need to import data from external files. If a worksheet is protected, importing or exporting data from external files is not supported. How can i lock and hide formula cells, as well as import / export data from/to external files. Thank you Regards Rema |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com