We help IT Professionals succeed at work.

VB.net Exel Add-in Edit SQL table in Excel

347 Views
Last Modified: 2014-05-11
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?
Comment
Watch Question

Top Expert 2008

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

Thomas
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Hi
The user will just edit/update the spreadsheet
Thanks
Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Top Expert 2008

Commented:
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
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks very much
Unlock the solution to this question.
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.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.