alvshill

You wouldn't believe it but after at least a few years of suffering this issue and within a couple of minutes of posting the issue, I've just thought of and tried a workaround. It is to introduce a short delay, 0.4 seconds in this instance, and the shortkey prefix completely removes itself every time. I guess MacExp is just too quick for Excel.

For some strange reason my prefix keys, which are "--" are not consistently removed in Excel when I try to trigger a macro from a cell. Sometimes the prefix completely removes itself, other times it removes a single "-", and at other time it doesnt removed the prefix at all. Does anyway know why this happens and/or how I can fix it? I'm using version 3.5.5.1 (3.5e build 1). While here I must say, so that that the world can see, Macro Express is the best thing since bread slicing machines were invented! I am called Macro-man at my place of work.