Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon visual state gets refreshed when multiple like workbooksopened
Hi All,
Is this a known Ribbon issue? When you open two like workbooks, the later workbook essentially refreshes the visual state of the original workbook. This effects ribbon controls with state such as checkboxes. It seems the internal state of the original workbook is not changed (thus the internal VBA state gets out of sync with the visual state). I have a workbook that opens other like workbooks to aggregate data across all user workbooks. After the aggregation macro runs if checkboxes were selected on the original, prior to the macro running, afterwards visually they are cleared (internally the VBA code still has the variables as selected). Any idea as to workarounds (i.e. pushing the visual state of the checkbox back to checked or reading the visual state to resyn the internal variables). Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) |