Avatar of Murray Brown
Murray Brown
Flag 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?
Visual Basic.NETMicrosoft Excel

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon
nutsch

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

Thomas
Murray Brown

ASKER
Hi
The user will just edit/update the spreadsheet
Thanks
ASKER CERTIFIED SOLUTION
Glenn Ray

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
nutsch

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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Murray Brown

ASKER
Thanks very much