I am able to copy a custom set of colours from an existing worksheet to a
new one. However I would prefer to change the default colours in all future
worksheets. I cannot find a "Normal" document as in MS Word. How can I do
this?

Michael Q

Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can I do
this?

Michael Q

Hello Bob,

Thank you I now have all new worksheets with the new default colours.

However on opening Excel instead of the woorksheet name being Book1 (and no
path) it appears as
"My Documents\Application Data\Microsoft\Excel\XLSTART\Book.xlt.xls"

Michael Q


"Bob Phillips" wrote in message
...
Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can I do
this?

Michael Q

It looks like you didn't really save that file as a template. Make sure you
choose that option from the "Save As Type" box at the bottom of the File|SaveAs
dialog.

(and don't forget to clean up that other file (book.xlt.xls, that is).)

Michael QC wrote:

Hello Bob,

Thank you I now have all new worksheets with the new default colours.

However on opening Excel instead of the woorksheet name being Book1 (and no
path) it appears as
"My Documents\Application Data\Microsoft\Excel\XLSTART\Book.xlt.xls"

Michael Q

"Bob Phillips" wrote in message
...
Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can I do
this?

Michael Q





--

Dave Peterson

Hi,

On this subject, i have a Book.xlt in this directory.

C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

The only other thing in the folder is my Personal.xls

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should.

Any ideas why?

thx
Dave
PS i am signed on as Owner

Bob Phillips Wrote:
Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet
to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can
I do
this?

Michael Q




--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

You've double checked that there is nothing else in that XLStart folder except
for personal.xls and book.xlt.

This is a guess...

How are you starting excel?

If you've created your own shortcut to excel.exe, is there any chance you told
it not to start with an empty workbook.

Using a command like:
c:\yourpathto\excel.exe /e
would stop the empty workbook (/e is that flag)

Maybe you could try:
close excel
windows start button|run
excel
and hit enter

does that work ok?

====
And one more guess--book.xlt hasn't been saved as a hidden workbook, right?

try: Window|Unhide
do you see anything


Piranha wrote:

Hi,

On this subject, i have a Book.xlt in this directory.

C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

The only other thing in the folder is my Personal.xls

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should.

Any ideas why?

thx
Dave
PS i am signed on as Owner

Bob Phillips Wrote:
Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet
to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can
I do
this?

Michael Q



--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

--

Dave Peterson

Hi Dave,
Thx for your reply. See below:
Dave Peterson Wrote:
You've double checked that there is nothing else in that XLStart folder
except
for personal.xls and book.xlt.

_Only_thing_in_the_XLStart_folder_is_Personal.xls_ and_Book.xlt._Snap_of_it,_is_attached._

This is a guess...
How are you starting excel?

If you've created your own shortcut to excel.exe, is there any chance
you told
it not to start with an empty workbook.

_I_have_a_short_cut_to_\"Excel.exe\"_on_a_button_o n_my_keyboard.
Double_checked,_it_is_just_\"c:\yourpathto\Excel.e xe\"_

Using a command like:
c:\yourpathto\excel.exe /e
would stop the empty workbook (/e is that flag)

Maybe you could try:
close excel
windows start button|run
excel
and hit enter

_I_did_this._Excel_opens_but_the_workbook_does_not _open._

does that work ok?

====
And one more guess--book.xlt hasn't been saved as a hidden workbook,
right?

_No,_just_the_\"Personal.xls\"_

try: Window|Unhide
do you see anything

_Just_the_Personal.xls_

Piranha wrote:

Hi,

On this subject, i have a Book.xlt in this directory.

C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

The only other thing in the folder is my Personal.xls

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should.

Any ideas why?

thx
Dave
PS i am signed on as Owner

Bob Phillips Wrote:
Save a workbook with the custom palette in the XLStart directory as
a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing
worksheet
to a
new one. However I would prefer to change the default colours in
all
future
worksheets. I cannot find a "Normal" document as in MS Word. How
can
I do
this?

Michael Q



--
Piranha

------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread:
http://www.excelforum.com/showthread...hreadid=475636

--

Dave Peterson


+-------------------------------------------------------------------+
|Filename: XLStart.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3909 |
+-------------------------------------------------------------------+

--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

I connect directly to the MS newsservers--so I don't see your snapshot. And
since this is a text only newsgroup, it's better to describe in words than post
binary attachments (pictures or files).

And you're sure book.xlt was saved as a template file--not as a normal workbook?

(I'm all out of guesses in any event.)

Piranha wrote:

Hi Dave,
Thx for your reply. See below:
Dave Peterson Wrote:
You've double checked that there is nothing else in that XLStart folder
except
for personal.xls and book.xlt.

_Only_thing_in_the_XLStart_folder_is_Personal.xls_ and_Book.xlt._Snap_of_it,_is_attached._

This is a guess...
How are you starting excel?

If you've created your own shortcut to excel.exe, is there any chance
you told
it not to start with an empty workbook.

_I_have_a_short_cut_to_\"Excel.exe\"_on_a_button_o n_my_keyboard.
Double_checked,_it_is_just_\"c:\yourpathto\Excel.e xe\"_

Using a command like:
c:\yourpathto\excel.exe /e
would stop the empty workbook (/e is that flag)

Maybe you could try:
close excel
windows start button|run
excel
and hit enter

_I_did_this._Excel_opens_but_the_workbook_does_not _open._

does that work ok?

====
And one more guess--book.xlt hasn't been saved as a hidden workbook,
right?

_No,_just_the_\"Personal.xls\"_

try: Window|Unhide
do you see anything

_Just_the_Personal.xls_

Piranha wrote:

Hi,

On this subject, i have a Book.xlt in this directory.

C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

The only other thing in the folder is my Personal.xls

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should.

Any ideas why?

thx
Dave
PS i am signed on as Owner

Bob Phillips Wrote:
Save a workbook with the custom palette in the XLStart directory as
a
template, named Book.xlt.

--
HTH

Bob Phillips

"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing
worksheet
to a
new one. However I would prefer to change the default colours in
all
future
worksheets. I cannot find a "Normal" document as in MS Word. How
can
I do
this?

Michael Q



--
Piranha

------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread:
http://www.excelforum.com/showthread...hreadid=475636

--

Dave Peterson

+-------------------------------------------------------------------+
|Filename: XLStart.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3909 |
+-------------------------------------------------------------------+

--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

--

Dave Peterson

Hi,
Well Dave Peterson gave me a whole bunch of much appricated help here,

and i have now found the answer to my problem.

The problem:
I have a Book.xlt in this directory:
C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should. only other
thing in the folder
is my Personal.xls

The Answer:
I have an alternate Start up folder, in which i have several regular
.xls workbooks.
Some are hidden and start up with Excel as hidden, along with my
Personal.xls.

That all works fine, but it blocks my "Book1" from opening. When i
close those hidden workbooks
so they are not hidden, then my "Book1" DOES open with Excel, along
with Personal.xls
opening as hidden.

So its a either / or situation, but not both.

Dave
Piranha Wrote:
Hi,
On this subject, i have a Book.xlt in this directory.
C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART
The only other thing in the folder is my Personal.xls
When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.
The "Personal.xls" file does open as hidden, like it should.
Any ideas why?
thx
Dave
PS i am signed on as Owner


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

Thanks for posting back. Now google has it for the next victim, er, person.



Piranha wrote:

Hi,
Well Dave Peterson gave me a whole bunch of much appricated help here,

and i have now found the answer to my problem.

The problem:
I have a Book.xlt in this directory:
C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART

When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.

The "Personal.xls" file does open as hidden, like it should. only other
thing in the folder
is my Personal.xls

The Answer:
I have an alternate Start up folder, in which i have several regular
xls workbooks.
Some are hidden and start up with Excel as hidden, along with my
Personal.xls.

That all works fine, but it blocks my "Book1" from opening. When i
close those hidden workbooks
so they are not hidden, then my "Book1" DOES open with Excel, along
with Personal.xls
opening as hidden.

So its a either / or situation, but not both.

Dave
Piranha Wrote:
Hi,
On this subject, i have a Book.xlt in this directory.
C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel\XLSTART
The only other thing in the folder is my Personal.xls
When i open Excel, the "Book1" does not open.
I have to go to File/New and click on workbook to open it.
The "Personal.xls" file does open as hidden, like it should.
Any ideas why?
thx
Dave
PS i am signed on as Owner

--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=475636

--

Dave Peterson