Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
I just changed to a new computer, fresh load of Office 2003, does
anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
Have you tried re-setting the toolbars.
Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in message oups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
Yeah tried that, if I hit the short cuts or go throught the menu the VBA IDE shows up as "FIND" in the alt-tab menu, it is like its visibility is set to false, which I thought was just odd. Thanks for the input however. Craig B On Nov 9, 2:28 pm, "Peter T" <peter_t@discussions wrote: Have you tried re-setting the toolbars. Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in ooglegroups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB- Hide quoted text -- Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
Oh and yes I have my cursor in a code window, it disappears, like the
focus has switched to the nonexsistent dialog box. CB On Nov 9, 2:28 pm, "Peter T" <peter_t@discussions wrote: Have you tried re-setting the toolbars. Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in ooglegroups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB- Hide quoted text -- Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
I don't quite follow that, when doing what.
Dim ctr As Object For Each ctr In _ Application.VBE.CommandBars(1).Controls("Edit").Co ntrols Debug.Print ctr.Caption, ctr.Enabled, ctr.Visible Next They might not be enabled but should be visible Regards, Peter T "Craig B" wrote in message ups.com... Oh and yes I have my cursor in a code window, it disappears, like the focus has switched to the nonexsistent dialog box. CB On Nov 9, 2:28 pm, "Peter T" <peter_t@discussions wrote: Have you tried re-setting the toolbars. Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in ooglegroups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB- Hide quoted text -- Show quoted text - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
Not sure but may be the dialog has been pushed off-screen (during a change
of the screen resolution) and not restored correctly. If you increase your screen resolution (if possible), can you see it ? [ I was going to suggest using Spy++ to find the window, but after a check (on my system where that dialog is clearly visible and shown as class "#32770 (Dialog)"), Spy++ cannot subsequently find it in a search and it does not appear as a child of the VBE main window, class "wndclass_desked_gsk". So I don't know if FindWindow/FindWindowEx/MoveWindow will work] NickHK "Craig B" wrote in message ups.com... Oh and yes I have my cursor in a code window, it disappears, like the focus has switched to the nonexsistent dialog box. CB On Nov 9, 2:28 pm, "Peter T" <peter_t@discussions wrote: Have you tried re-setting the toolbars. Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in ooglegroups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB- Hide quoted text -- Show quoted text - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA edit menu actions
Hey Pete,
You rock! Thanks for the assistance, that did the trick. Appreciate everyone's assistance with this amazingly annoying issue. Didn't think I used those functions as much as I do! Craig Peter T wrote: I don't quite follow that, when doing what. Dim ctr As Object For Each ctr In _ Application.VBE.CommandBars(1).Controls("Edit").Co ntrols Debug.Print ctr.Caption, ctr.Enabled, ctr.Visible Next They might not be enabled but should be visible Regards, Peter T "Craig B" wrote in message ups.com... Oh and yes I have my cursor in a code window, it disappears, like the focus has switched to the nonexsistent dialog box. CB On Nov 9, 2:28 pm, "Peter T" <peter_t@discussions wrote: Have you tried re-setting the toolbars. Do Ctrl-F & Ctrl-H Is the cursor in a code module Regards, Peter T "Craig B" wrote in ooglegroups.com... I just changed to a new computer, fresh load of Office 2003, does anyone out there have any idea why my Edit Find command, or Edit-- replaced commands no longer show thier dialog box on screen? Very odd behavior. CB- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Can I Edit Excels Help Menu? | Excel Discussion (Misc queries) | |||
Problems with Edit Menu | Setting up and Configuration of Excel | |||
Multiple Edit menu | Excel Discussion (Misc queries) | |||
Actions between user actions | Excel Programming | |||
Edit Menu | Excel Discussion (Misc queries) |