Hi I was wondering if i could get some help here with a thing I'm trying to create for my workplace. We are a school for special needs children and most of my colleagues can barely turn on a computer. yet we will soon be obliged to a digital workspace. for this we need forms for rapports documentation etc. So we've al decided on Excel for our daily reporting on the work and progress of our pupils. Ideally the Excel sheet wil have 31 tabs for a month, each tab a printable form (A4 size) for us to wrtie stuff into. I've managed to create a cell-les form with closed cells that really looks like what we need. Í've found the developer tab and managed to start a bunch of active-x text fields. but this is were i got stuck.

Everything needs to be closed of for the users to prevent accidents but the text fields need to be usable and have scroll bars for large amounts of text (and also remain readable)

How do i position the active x fields in such a way that they are aligned. Can grow a little bit with much text and also create scroll bars if the text field gets to a certain size.

The form will have 8 or so text fields and it would be good if everything moved down to the second page if the text field grow due to input.

So in short it really needs to work like word but we want excel because we are comfertable with the idea that certain areas can be closed of for editing. Als at some point we will need to do some databasing because we would like to keep track of how often a pupil came to class.

I should mention that this is the first time i really tried to get into Excel but i have no idea where to go... We teachers are a bit to old school i think ;)

I hope somebody would like to take a look at this.

Kind regards

Bram