Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

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?
Avatar of nutsch
nutsch
Flag of United States of America image

Does the user edit update the database or just the spreadsheet?

Thomas
Avatar of Murray Brown

ASKER

Hi
The user will just edit/update the spreadsheet
Thanks
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Thanks very much