Excel Design Formatting

[saadferoze]

Dear Members,


I have almost completed my Model and would like to design it so it doesnt look like excel. I wanna make it look like forms. Is there any way to do it or any other way through which it looks very professional.


Regards

Saad

 

[dan_l]

You can create forms in VBA. Just open up the editor, insert a form.

 

[Hui]

Saad


Turn off the Gridlines

Turn off the Row/Column headers

Turn off the Formula Bar

Restrict scrolling to allowable areas

Hide the menus

Maximize the screen

Add controls as appropriate, which auto start and controls to close the workbook

Password protect data areas and unprotect user areas as appropriate