(Msg. 1) Posted: Wed Jan 30, 2008 8:30 am
Post subject: No X on a worksheet of a template Add to elertz Archived from groups: microsoft>public>excel>templates (more info?)
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?
(Msg. 2) Posted: Wed Jan 30, 2008 11:36 am
Post subject: Re: No X on a worksheet of a template Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
On Wed, 30 Jan 2008 08:30:02 -0800 (PST), Mike <m_hightower RemoveThis @hotmail.com> wrote:
>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
(Msg. 3) Posted: Wed Jan 30, 2008 3:11 pm
Post subject: Re: No X on a worksheet of a template Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Jan 30, 1:36 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> 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
>
> On Wed, 30 Jan 2008 08:30:02 -0800 (PST), Mike <m_highto....DeleteThis@hotmail.com> wrote:
> >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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office