Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm using Office 2007 on Windows XP; I have coded a dictator program that incorporates similar code to the following (I say similar because I have tweaked it somewhat and it is sort of complex to describe concisely here): Private Function DicatorMode(argTrueFalse As Boolean) 'ExecuteExcel4Macro portion by Jim Rech; other code Nick hodge; With Application .ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon""," & argTrueFalse & ")" .CommandBars("Status Bar").Visible = argTrueFalse If argTrueFalse = False Then .Caption = "User Mode" Else .Caption = "" .ShowWindowsInTaskbar = argTrueFalse End With ActiveWindow.View = xlNormalView ActiveWindow.WindowState = xlMaximized End Function The problem is, when this code runs, if the user opens a new XL file, in the same instance, it is also in dictator mode, but then my shortcut menus are unavailable, thus locking the user in a "stray" file with no way out. Is there a way to alter the code to prevent this from happening? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dictator Apps and Excel 2007 | Excel Programming | |||
Dictator App | Excel Discussion (Misc queries) | |||
Making a [semi] Dictator Application: Hiding Main Command Bar? | Excel Discussion (Misc queries) | |||
Making a [semi] Dictator Application: Hiding Main Command Bar? | Excel Programming | |||
Program question | Excel Programming |