I have three questions regarding putting a spreadsheet within a userform.
1) can you prevent people from selecting/changing cells?
- I will be populating the spreadsheet with some code not just referencing other cells and do not know how to turn protection on/off via VBA if it is even possible?
2) How can you set the alignment in the cells? I want to have the title cells center aligned.
3) How do you clear the cells without having to set each individual cell = ""?
1) can you prevent people from selecting/changing cells?
- I will be populating the spreadsheet with some code not just referencing other cells and do not know how to turn protection on/off via VBA if it is even possible?
2) How can you set the alignment in the cells? I want to have the title cells center aligned.
3) How do you clear the cells without having to set each individual cell = ""?
