Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! - SWITCHBOARD NEEDED
Dear all,
Please can you tell me how to add a "switchboard" to an excel sheet so that when the file is opened a created menu appears and Excel is effectively hidden (basically a switchboard similar to that in Access) Thanks for your help Sarah |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! - SWITCHBOARD NEEDED
You need a userform. Here is some reading material
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- HTH RP (remove nothere from the email address if mailing direct) "Sarah_Lecturer" wrote in message ... Dear all, Please can you tell me how to add a "switchboard" to an excel sheet so that when the file is opened a created menu appears and Excel is effectively hidden (basically a switchboard similar to that in Access) Thanks for your help Sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solver related some financial knowledge may be needed | Excel Discussion (Misc queries) | |||
Switchboard for excell | Excel Discussion (Misc queries) | |||
formula results take up to 2 lines if needed, but keep border | Excel Worksheet Functions | |||
Urgent Help Needed with coloumn compare | Excel Discussion (Misc queries) | |||
Custom percent format needed | Excel Worksheet Functions |