Sendkeys issue
You can try adding a DoEvents line immediately after the sendkeys line. This
might help. I have not tested it but that is what I would try first.
"Michael Malinsky" wrote:
I have some code I'm running to change printer properties. I've
successfully been able to change the needed properties, but only works
for the currently selected sheet. I tried running a loop such as:
For each sh in Worksheets
sh.Activate
Application.SendKeys {"%fu")
.
.
.
Next sh
but it first loops through activating each sheet before executing any
of the SendKeys statements.
From what I've read in the NGs, SendKeys can be messy, but I don't seem
have another option. Any ideas?
Thanks,
Mike.
|