asked on 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?
Visual Basic.NETMicrosoft Excel
Last Comment
Murray Brown
ASKER
Hi
The user will just edit/update the spreadsheet
Thanks
The user will just edit/update the spreadsheet
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
ASKER
Thanks very much
Thomas