Lock font size

[bassls]

I want to allow users to change data in a cell(s), but prevent them from changing the font, size, style, or anything else. Would creating a form be best?

 

[bassls]

Again being a newbie, can you explain the before print event?

 

[Atroxell]

You can look at this:

http://msdn.microsoft.com/en-us/lib....tools.excel.workbook.beforeprint(VS.80).aspx

It will probably do a better job than I will at explaining.

You will have to go into the VBE and find "ThisWorkbook". Doubleclick on it to open it, then click on the dropdown above the code window that says "(General)" to expose the "Workbook" option. Select "Workbook".

To the right of that you will see another dropdown, probably saying "Open". Scroll through that list to find the "BeforePrint" event. The code

Private Sub Workbook_BeforePrint(Cancel As Boolean)
 
End Sub

should appear in the code window. That will be where you put your code to revert everything to 12 point Arial...

I imagine it will look something like:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
 
     Range("A1:A10").Font.Size = 12
     Range("A1:A10").Font.Name = arial
     Range("A1:A10").Font.Bold = True
 
End Sub