Hi,

I've inherited an Excel template that applies application methods (suc
as hiding a custom menu) when the workbook is activated. I receive
quite a few user complaints on not able to copy into the template fro
another workbook. I stepped through the code and realized that tha
every time after the user switches back to the template, th
application methods are executed, and then the ability to paste usin
Edit/Paste or Paste Special is lost. It seems this is the cas
everytime a menu command is executed. I know the user can paste it fro
the clipboard, but it's an inconvenience that she has to pick out th
item to paste and the paste operation changes the format of the targe
cells. I wonder if anybody knows how to get around this problem. T
see this problem, open two workbooks. In the first work book, put i
something like this:

Private Sub Workbook_Activate()
application.displayformulabar = false
End Sub

Copy something using Ctrl-C in the second workbook, switch back to th
first and then try to paste. It doesn't work, although you can find th
contents still in the clipboard.

Thanks for any insight.

spacecitygu

--
Message posted from http://www.ExcelForum.com