Is there anyway to select a tool bar button from within a macro?
and if so, once you complete the command you are selecting, will it return
to the original macro?
Is there anyway to select a tool bar button from within a macro?
and if so, once you complete the command you are selecting, will it return
to the original macro?
Maybe you can use execute
This will open printpreview
MsgBox "Hi"
Application.CommandBars("Standard").FindControl(ID:=109).Execute
MsgBox "Hi again"
--
Regards Ron de Bruin
http://www.rondebruin.nl
"jasminesy" <jasminesy@discussions.microsoft.com> wrote in message news:46FA5D07-46C6-48BD-B537-8AF101A5628B@microsoft.com...
> Is there anyway to select a tool bar button from within a macro?
> and if so, once you complete the command you are selecting, will it return
> to the original macro?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks