Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3 Questions actually!
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 |
#2
|
|||
|
|||
3 Questions actually!
I can answer your third question:
if A1 contains 1 and B1 contains 2 then use the formula: =A1 & " to " & B1 -- Gary''s Student "grandfilth" wrote: 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 |
#3
|
|||
|
|||
3 Questions actually!
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 |
#5
|
|||
|
|||
3 Questions actually!
Sorry, I'm not the best at excel...How do you apply these macros? Where do i type them, how do i link them to my program? Chip Pearson Wrote: 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 ------------------------------------------------------------------------ grandfilth's Profile: http://www.excelforum.com/member.php...o&userid=28240 View this thread: http://www.excelforum.com/showthread...hreadid=478450 |
#6
|
|||
|
|||
3 Questions actually!
PLese can someone help me understand this, I'm having problems, i tried to start up a userform, but I was pretty unsure about how to do it. I want something that will make my program appear with any of the excel things showing. -- grandfilth ------------------------------------------------------------------------ grandfilth's Profile: http://www.excelforum.com/member.php...o&userid=28240 View this thread: http://www.excelforum.com/showthread...hreadid=478450 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table questions | Excel Discussion (Misc queries) | |||
Where can I post Macro questions? | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Puzzling Format Questions | Excel Discussion (Misc queries) | |||
Questions about MS Word | Excel Discussion (Misc queries) |