ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format as Table (https://www.excelbanter.com/excel-programming/435501-format-table.html)

Nauman Khan

Format as Table
 
Is it possible to autoprotect certain cells after a vaule has been entered so
it cannot be modified.
The cells to be protected after data is entered a
C2:E2 (merged)
I2
L2
N2
B4

Also, the Format as Table feature does not work in excel once Protect Sheet
& Protect and Share Workbook features with tracking are turned on(password
protected). Is there a way around this?

Any help will be much appreciated.


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com