Protected Sheet and Cell Formating

kakiebos

Board Regular
Joined
Jun 10, 2018
Messages
59
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.
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Oh wow, if this was me I definitely would NOT want to allow users to change the font to suit themselves.
But if you want to do that, why not include within your existing code, some new code towards the end to reset the row height / column width back to whatever they should be.
 

Forum statistics

Threads
1,084,820
Messages
5,380,097
Members
401,647
Latest member
DougWK

Some videos you may like

This Week's Hot Topics

Top