1) Create a userform that will serve as the interaction between
your application and Excel. In the Initialize event, hide the
Application, and in the Terminate event, show the Application.


Private Sub UserForm_Initialize()
Application.Visible = False
End Sub

Private Sub UserForm_Terminate()
Application.Visible = True
End Sub

2) Set the Saved property of the workbook to True. This will tell
Excel that the workbook does not need saving, and the changes
won't be saved.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub

3) Use the & operator to concatenate text from cells.
=A1&B1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"grandfilth"
wrote
in message
...

HI, first:

I've made a program in excel, and when it loads up i would like
only
the program i've made to show, and not any of the excel stuff
like the
formula bar, or even the column and row letters/numbers, is
this
possible?

I would also like to know if it's possible that when someone
presses
the x to close excel they do not get the choice to save what
they have
done.

Last question, if i have 2 cells with figures in (e.g. A1 and
B1) can i
make a third cell say (A1 "to" B1)?

Any help would be much appreciated...


--
grandfilth
------------------------------------------------------------------------
grandfilth's Profile:
http://www.excelforum.com/member.php...o&userid=28240
View this thread:
http://www.excelforum.com/showthread...hreadid=478450