software

After saving a training/practice worksheet, it keeps causing the training
frame to open every time I open this worksheet....how do I prevent this from
happening?

I'm going to guess that it's being opened with some code attached either to
the workbook or that specific sheet. You can find out if that's the case by
using the Visual Basic Editor to try and find the code and removing it. The
code may not show up when you choose Macro | Macros if they are designated as
Private.

Just in that one .xls file, right? Perhaps even just on one sheet in the
book?

quot;bernie b.quot; wrote:

gt; After saving a training/practice worksheet, it keeps causing the training
gt; frame to open every time I open this worksheet....how do I prevent this from
gt; happening?

I could not find any code causing this to happen....I finally created a new
spreadsheet and copied all my worksheets over to the new one.....that took
care of the problem...wish I knew what caused it in the first place
though....thanks for your suggestions.

quot;JLathamquot; wrote:

gt; I'm going to guess that it's being opened with some code attached either to
gt; the workbook or that specific sheet. You can find out if that's the case by
gt; using the Visual Basic Editor to try and find the code and removing it. The
gt; code may not show up when you choose Macro | Macros if they are designated as
gt; Private.
gt;
gt; Just in that one .xls file, right? Perhaps even just on one sheet in the
gt; book?
gt;
gt; quot;bernie b.quot; wrote:
gt;
gt; gt; After saving a training/practice worksheet, it keeps causing the training
gt; gt; frame to open every time I open this worksheet....how do I prevent this from
gt; gt; happening?

In that case we'll just let it go as Fixed! But since you solved it by
copying the actual sheets to a new workbook, the code wasn't associated with
any sheet, although it may have been part of the workbook, or an add-in it
was dependent on.

quot;bernie b.quot; wrote:

gt; I could not find any code causing this to happen....I finally created a new
gt; spreadsheet and copied all my worksheets over to the new one.....that took
gt; care of the problem...wish I knew what caused it in the first place
gt; though....thanks for your suggestions.
gt;
gt; quot;JLathamquot; wrote:
gt;
gt; gt; I'm going to guess that it's being opened with some code attached either to
gt; gt; the workbook or that specific sheet. You can find out if that's the case by
gt; gt; using the Visual Basic Editor to try and find the code and removing it. The
gt; gt; code may not show up when you choose Macro | Macros if they are designated as
gt; gt; Private.
gt; gt;
gt; gt; Just in that one .xls file, right? Perhaps even just on one sheet in the
gt; gt; book?
gt; gt;
gt; gt; quot;bernie b.quot; wrote:
gt; gt;
gt; gt; gt; After saving a training/practice worksheet, it keeps causing the training
gt; gt; gt; frame to open every time I open this worksheet....how do I prevent this from
gt; gt; gt; happening?