J
JLC
I'm so thankful for Jim Rech's code* (and those who directed me to it)
that allows auto-expansion of merged cells, but I have a *shared
workbook *with at least *10 sheets*, each of which has more than *40
different merged cells *that may need auto-expansion. Because there are
so many merged cells, not to mention Excel-phobic users typing into
them, I want to avoid personally running this macro for each cell that
needs expansion. Unfortunately, my _very_ rudimentary VBA skills are of
no help.
Given that, I have several questions:
- Can I have the macro run automatically for each sheet, checking all
the merged cells (or simply all cells), when the user saves or exits?
- Can I have the macro check every single cell in the workbook? I'd
like to run this version manually.
- Can the macro activation event be when the user has finished
entering text and moves to a new cell whether by
- tabbing,
- hitting enter, or
- clicking on the next cell they want to modify?
If so, does anyone know how expensive this would be in terms of time
and memory? All my users are accessing the workbook remotely and
already have a good deal of lag due to outdated equipment.
*'Jim Rech's AutoFitMergedCellRowHeight Code'
(http://tinyurl.com/aknxy)
that allows auto-expansion of merged cells, but I have a *shared
workbook *with at least *10 sheets*, each of which has more than *40
different merged cells *that may need auto-expansion. Because there are
so many merged cells, not to mention Excel-phobic users typing into
them, I want to avoid personally running this macro for each cell that
needs expansion. Unfortunately, my _very_ rudimentary VBA skills are of
no help.
Given that, I have several questions:
- Can I have the macro run automatically for each sheet, checking all
the merged cells (or simply all cells), when the user saves or exits?
- Can I have the macro check every single cell in the workbook? I'd
like to run this version manually.
- Can the macro activation event be when the user has finished
entering text and moves to a new cell whether by
- tabbing,
- hitting enter, or
- clicking on the next cell they want to modify?
If so, does anyone know how expensive this would be in terms of time
and memory? All my users are accessing the workbook remotely and
already have a good deal of lag due to outdated equipment.
*'Jim Rech's AutoFitMergedCellRowHeight Code'
(http://tinyurl.com/aknxy)