Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Form
I am using Excel 2007 on Windows XP with dual monitors. I have a work
book that is to be shared that has a form that I built. The form is not modal but I am unable to switch to another workbook in Excel when the form is displayed. I figured out that I can switch back and forth between two workbooks when the second one is in a separate instance of Excel. So I am wondering if I can have Excel and one workbook open then open a second wb and force it to open a second instance of Excel. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Form
On 14 Aug, 00:18, Slim Slender wrote:
I am using Excel 2007 on Windows XP with dual monitors. I have a work book that is to be shared that has a form that I built. The form is not modal but I am unable to switch to another workbook in Excel when the form is displayed. I figured out that I can switch back and forth between two workbooks when the second one is in a separate instance of Excel. So I am wondering if I can have Excel and one workbook open then open a second wb and force it to open a second instance of Excel. Could I just ask, why do you need to have your form open whilst you are trying to switch to the 2nd workbook? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Form
Could I just ask, why do you need to have your form open whilst you
are trying to switch to the 2nd workbook? Turns out it isn't necessary to open another instance of Excel. What I do need is a way of preventing a user from using Alt+F8 and Alt +F11 and seeing or using macros except for one macro. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Form
On 18 Aug, 01:18, Slim Slender wrote:
Could I just ask, why do you need to have your form open whilst you are trying to switch to the 2nd workbook? Turns out it isn't necessary to open another instance of Excel. What I do need is a way of preventing a user from using Alt+F8 and Alt +F11 and seeing or using macros except for one macro. There are at least three ways of hiding a macro. 1. define the macro(s) as Private 2. place the macro(s) in an addin 3. define the macro to be hidden with a dummy variable e.g. Sub HiddenMacro(byval dummy as integer) ... code as normal ... End Sub Then call this from your master sub Sub Master ... code as normal ... Call HiddenMacro(1) ' (the 1 is a dummy variable and has no use other than hidding the above macro) .... code as normal ... End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Custom Form, .frx .frm files | Excel Programming | |||
Custom Form Closing | Excel Programming | |||
Creating a Custom Form | Excel Discussion (Misc queries) | |||
Custom User Form | Excel Programming | |||
Custom Form Coding | Excel Programming |