Hi,
It's a long time since I have used VBA and I'm trying to lock and save a number of cells after data entry via a macro button. The user will have 2 buttons as options-
Option 1:
I want the user to click this button if they want to save Week 1 predictions in cells F11:F25 and H11:H25
Once they have been saved the cells I want them to be locked to stop them amending the scores
If they want to enter predictions for more than one week they can move onto Week 2 as the workbook will remain Open
Option 2:
I want the user to click this button if they want to save Week 1 predictions in cells F11:F25 and H11:H25 BUT
they DO NOT want to enter any further predictions, the cells are locked and the Workbook is Closed
Thanks for any help you can give, John
It's a long time since I have used VBA and I'm trying to lock and save a number of cells after data entry via a macro button. The user will have 2 buttons as options-
Option 1:
I want the user to click this button if they want to save Week 1 predictions in cells F11:F25 and H11:H25
Once they have been saved the cells I want them to be locked to stop them amending the scores
If they want to enter predictions for more than one week they can move onto Week 2 as the workbook will remain Open
Option 2:
I want the user to click this button if they want to save Week 1 predictions in cells F11:F25 and H11:H25 BUT
they DO NOT want to enter any further predictions, the cells are locked and the Workbook is Closed
Thanks for any help you can give, John
