VB.net Exel Add-in Edit SQL table in Excel
Hi
I would like to Edit a SQL table in an Excel spread sheet without allowing the user to delete rows or columns. What is the best way to achieve this?
I would like to Edit a SQL table in an Excel spread sheet without allowing the user to delete rows or columns. What is the best way to achieve this?
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
If you're just updating the spreadsheet, then unlock the cells (by going to Cells \ Format \ Protection (or Ctrl+1 \ Protection and uncheck the Locked checkbox), then protect the worksheet - Alt T P P or Review \ Protect Sheet.
The user can now update the cell values, but not delete columns or rows.
Thomas
The user can now update the cell values, but not delete columns or rows.
Thomas
Join our community and discover your potential
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.