You have chosen to sponsor your bid up to a maximum amount of .
Existing VBA code needs to be changed.
Successful bidder will be sent the existing coed along with an explanation of it's functionality. New code will be written to perform requirements for project. Code must be fully commented and will require a suitability test before payment is released. Approximately 20 code snips to be updated, varying in complexity. A sample is included below and it's suitability will be a basis for selection for the project listed.
Existing code is:
Dim ws As Worksheet
Application.DisplayAlerts = False
For Each ws In Worksheets
If ws.Name "DATA" Then ws.Delete
Application.DisplayAlerts = True
Requirements for new code:
User can decide to designate other sheets that will not be deleted by means of checkoxes in worksheet. Design of sheet is not in the scope of this test. Just alter code to reflect desired outcome if any checkbox is clicked that corresponds to a range of A1:A10 in active worksheet in addition to DATA sheet.