No X on a worksheet of a template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 30 Jan 2008 16:30 GMT

Hello. There are some templates we use to display report data in Excel
2003. Whenever these open inside Excel there is no X (to close)
for that worksheet. You can only close the whole Excel application
which is sometimes not desirable if you have multiple reports open.
Is the X something that can be coded to display on the worksheets?

thanks

Reply to this Message

Gord Dibben - 30 Jan 2008 19:36 GMT

Sounds like the workbook is protected.

Tools>Protection>Unprotect Workbook.

If that is the case, you will have to alter the original Templates to have the
protection off.

Gord Dibben MS Excel MVP

>Hello. There are some templates we use to display report data in Excel
>2003. Whenever these open inside Excel there is no X (to close)
[quoted text clipped - 3 lines]
>
>thanks

Reply to this Message

Mike - 30 Jan 2008 23:11 GMT

> Sounds like the workbook is protected.
>
[quoted text clipped - 12 lines]
>
> >thanks

That was it! Thanks for the help.

Reply to this Message