| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Very weird - Code does not work until after file is saved???
My code is opening various workbooks, copying existing worksheets into
ThisWorkbook, and then closing the various workbooks. I am trapping clicks on all charts so that a Chart Window opens. Then, the chart is supposed to resize. Upon copying in the worksheets, clicking a chart will always open the chart window. But, the chart window will not resize (initially). Only AFTER saving the workbook (or waiting for the AutoRecover time to pass) will the chart window resize upon clicking. Any insights to this one? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running code before any file is opened/saved | Excel Programming | |||
| Code does not work on emailed file | Excel Discussion (Misc queries) | |||
| Hyperlink Code only works when file saved on desktop | Excel Programming | |||
| Weird Problem: Excel SaveAs-- document not saved | Excel Programming | |||
| VBA Saving code causes SAVED file to be corrupt | Excel Programming | |||
Threaded Mode
