Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: Row transposing; event on open vs. shortcut key
I have a macro that formats data from one sheet and places it into
another. I assigned the a shortcut key. When I execute the shortcut key everything works great. However, when I put the same Sub in the OnOpen event of the Excel workbook (to save users the trouble of having to execute this macro manually everytime they open the file) it DOESN'T work. Rather several of the columns are transposed and the row mapping from one sheet to the other isn't exact either. I'm at a loss. If the exact same code is being executed it should either work by shortcut key AND OnOpen event...or else neither of them should work. Is this a known Excel bug of some type? Any comments appreciated... Thanks, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
Macro doesn't work when used as Workbook Open event | Excel Discussion (Misc queries) | |||
macro for transposing data | Excel Discussion (Misc queries) | |||
user form-on open event? keydown event? | Excel Programming | |||
Insert VBA code with a macro in a .xls file by workbook open event | Excel Programming |