I created a document, Job Card, for our technicians to fill in after completion of work. There is plenty formulas in there as well as certain size constraints for printing purposes. Therefore I protected the sheet with a password. Pretty straight forward.
Some of the technicians want to be able to change the font for the sections that they fill in. (Kind of a personal signature/personality thing) I have no issues with that. Firstly I would like to create a VBA code for them to be able to do this. I will create my code by selecting all the ranges that they is filled in, including those with the formulas that is locked. They must choose the font name, and enter that into a provided space/cell and run the code by means of a form control button. One of my issues that I currently have is that when some fonts are chosen, the cell width or height are automatically adjusted. I would like to prevent this, as this will affect the print region. Especially if the cells are now bigger than before.
Is there some code that I can use to prevent the cells from auto size with a font change?
Thanks in advance for your assistance.
Some of the technicians want to be able to change the font for the sections that they fill in. (Kind of a personal signature/personality thing) I have no issues with that. Firstly I would like to create a VBA code for them to be able to do this. I will create my code by selecting all the ranges that they is filled in, including those with the formulas that is locked. They must choose the font name, and enter that into a provided space/cell and run the code by means of a form control button. One of my issues that I currently have is that when some fonts are chosen, the cell width or height are automatically adjusted. I would like to prevent this, as this will affect the print region. Especially if the cells are now bigger than before.
Is there some code that I can use to prevent the cells from auto size with a font change?
Thanks in advance for your assistance.