Editable areas
Hi dear members.
I want to make editable only yellow marked areas. Can anyone help me with this?
Thanks in advance!
Attachment | Size |
---|---|
Editable areas.xlsx | 14.24 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 703 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Editable areasHi dear members.
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Hi Batya Highlight all yellow
Hi Batya
Highlight all yellow cells, select format cells, go to protection tab and uncheck the locked box and select ok.
Go to file ? Info ? protect workbook ? Protect Current sheet. insert a password of your choice.
Now all cells apart from those you've unlocked cannot be edited without the password to unprotect.
Regards
Mark