It just does this, how? As Paul pointed out twice, if you don't display the
code, or konwing where you're saving the file (is it overwriting the sheet1
or book1 template in the XLSTART directory, for instance?), you're not
letting us help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Hi,
It just displays an excel sheet - nothing more than that. Can't
undeerstand why calling the addin "keeps" the data entered though?
There's nothing in the code for that.


"groupie" wrote in message
...
On Jun 20, 10:00 am, wrote:
Hi
As always, we need to see the AddIn code. More specifically, we need
to see the code that is run when the menu item is selected.
regards
Paul

On Jun 20, 9:38 am, groupie wrote:



Hi,
An AddIn creates a menu item which opens a new excel form (with a
little bit of formatting: colours etc.). When this file is saved -
under a different filename, in a different directory, with .XLS - and
excel is closed down afterwards, when the menu item is selected again,
it seems to open the file just saved - has all the data etc.

Any ideas? Why doesn't the blank form display again when the menu
option is selected? Thanks.- Hide quoted text -

- Show quoted text -