If I use:
SendKeys ("%fdm")
from a standard macro it works fine. However if I try to use the exact same code from a button on a Userform I see the file menu flash real quick but nothing happens. I even tried having the commandbutton on the userform call the macro and it won't work.
If I put a form button on the sheet directly and assign the macro to it, it works. But if I try it from a Userform it just will not work?
This one has me pulling my hair out..
advance thanks
SendKeys ("%fdm")
from a standard macro it works fine. However if I try to use the exact same code from a button on a Userform I see the file menu flash real quick but nothing happens. I even tried having the commandbutton on the userform call the macro and it won't work.
If I put a form button on the sheet directly and assign the macro to it, it works. But if I try it from a Userform it just will not work?
This one has me pulling my hair out..
advance thanks