this really isn't very clear. what is a Row Command Bar?



"J Streger" wrote in message
...
I read the long discussion that Ron and Peter were trying to answer back
in
2005, but another solution was found prior to answering question in the
OP.

I am trying to take control of the Inser Copied Cells button on the Row
CommandBar. It is not cooperating very well, as the button appears and
disappears, thus clearing any changes I make to it. So far I know:

1) The option will only appear after a CutCopyMode is not longer false
2) The option will only appear once the user activates the Row Menu.

So I cannot seem to access this command until the menu becomes visible,
but
I can't seem to do anything to menu while it's visible. I tried adding an
Application.OnTime event, but that won't fire if the menu is visible.
Essentially I can take over the menu if the user shows it and then selects
elsewhere, but if the show it for the first time, I cannot control that
option.

I'm trying to take it over so that users do not have the ability to copy
formatting from another location into a specific sheet. They need to have
the
ability to copy rows or insert rows, but I jusst don't want the formatting
to
come with it. I've hijacked all other means, just this one seems
impossible
to control. Any idea?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003