| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.activate acts dif when activewindow.caption changed
Normally the active sheet in a workbook doesn't change when the workbook is
activated. After setting the ActiveWindow.Caption to something new: Workbook.activate changes the active sheet to Worksheets(1) no matter what the previous active sheet was. Can someone confirm this behavior? Can someone explain this? Can someone comeup with way to regain normal behavior? -- JC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activate speech when sheet is changed | Excel Programming | |||
| Can Multiple Range Pivot Table's field button's caption be changed | Excel Discussion (Misc queries) | |||
| Change Worksheet Button Caption on Worksheet.Activate | Excel Programming | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| How can the caption of a (button) shape (not cmd) be changed from VBA | Excel Programming | |||
Threaded Mode
