Zero


Ad

Advertisements

B

Bob Phillips

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.
 
L

Loris

I tried this but got an error message that said the XLSTART folder was read
only and it wouldn't let me save anything to it. In it's properties, the
Read-Only check box says it applies only to files withing the folder. How do
I change the attribute to the folder itself?

Bob Phillips said:
Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.
 
F

flatwall

Thanks Bob, Your solution sounds OK to me and I will try it. Thanks for
taking the time to respond, I appreciate it.
--
flatwall
trying to live down retirement without falling off the edge!!


Bob Phillips said:
Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.
 
B

Bob Phillips

BTW, if you want any added worksheets to also have that property, you need
to create a single sheet workbook with that option set and save that as
Sheet.XLT in the folder.

--
__________________________________
HTH

Bob

flatwall said:
Thanks Bob, Your solution sounds OK to me and I will try it. Thanks for
taking the time to respond, I appreciate it.
 
Ad

Advertisements

B

Bob Phillips

cn't you right-click the folder and select Properties and change it there?

--
__________________________________
HTH

Bob

Loris said:
I tried this but got an error message that said the XLSTART folder was read
only and it wouldn't let me save anything to it. In it's properties, the
Read-Only check box says it applies only to files withing the folder. How
do
I change the attribute to the folder itself?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top