Allow Excel to work off of Excelnn.xlb and XLStart located under the
Documents and Settings\All Users folder instead of the individual \Username
folders. On my personal computer I have an Administrator account for normal
use and a Limited Access User account for Internet browsing and email, as
recommended for security. I would like the same Excel configuration
(Toolbars and Macros) for both accounts. This can be done in Word by putting
the Normal template in a folder accessible to both, and pointing Word in both
accounts to that folder for templates. In Excel, however, something similar
cannot be done so that toolbar & macro changes by me as one user (e.g., the
Administrator) are automatically available to me as the other user(s) (the
Limited Access User(s)).
--
kxxxk

Just a thought... You could try making a shortcut of your XLSTART file
from your administrator account and place it in your limited access
account in place of the XLSTART file there. I'm not sure Excel will
recognize the shortcut file or not.

Another method which, someone else would have to help you with the
code, is possibly a macro that would run when you start Excel in your
limited access account that would copy and then open the administrator
account's XLSTART file to your limited access account. I'd try and help
you with the code but my macro writing skills aren't up to that point
yet. Sorry, but hope my suggestions help. Good Luck!

kxxxk Wrote:
Allow Excel to work off of Excelnn.xlb and XLStart located under the
Documents and Settings\All Users folder instead of the individual
\Username
folders. On my personal computer I have an Administrator account for
normal
use and a Limited Access User account for Internet browsing and email,
as
recommended for security. I would like the same Excel configuration
(Toolbars and Macros) for both accounts. This can be done in Word by
putting
the Normal template in a folder accessible to both, and pointing Word
in both
accounts to that folder for templates. In Excel, however, something
similar
cannot be done so that toolbar & macro changes by me as one user (e.g.,
the
Administrator) are automatically available to me as the other user(s)
(the
Limited Access User(s)).
--
kxxxk


--
PapaBear56

The problem is not Personal.xls (the macros) in XLStart, the problem is with
Excellnn.xlb (Excel11.xlb in Excel 2003) which contains the toolbar
customizations and is always stored in C:\Documents and
Settings\Username\Application Data\Microsoft\Excel. If Excel is opened in
the Username account, Excel 2003 always goes to this location and opens the
Excel11.xlb that is therein. If there is no such file at that location,
Excel opens with its default toolbar configuration. Changes in toolbars are
always saved on closing to Excel11.xlb at that same (Username) location.
There is no getting around this currently. (Note that Excel 2003 does NOT
use C:\Program Files\Microsoft Office\Office11\XLStart\Book.xlt as Excel Help
says it does in "Customize How Excel Starts". As I recall, Excel 97 used to
use such a template.) My request is that the Administrator account be
allowed an option to have Excel use Excel11.xlb (in its opening and in its
closing - in its saving of toolbar modifications) in the folder C:\Documents
and Settings\ALL USERS\Application Data\Microsoft\Excel _regardless of the
Username account in which Excel is opened_, so that those of us with personal
computers can always access our current configuration of Excel whether we are
using either our Administrator account or our Limited-Access-User account to
avoid spyware being put on our machine when Internet connected.--
kxxxk


"PapaBear56" wrote:


Just a thought... You could try making a shortcut of your XLSTART file
from your administrator account and place it in your limited access
account in place of the XLSTART file there. I'm not sure Excel will
recognize the shortcut file or not.

Another method which, someone else would have to help you with the
code, is possibly a macro that would run when you start Excel in your
limited access account that would copy and then open the administrator
account's XLSTART file to your limited access account. I'd try and help
you with the code but my macro writing skills aren't up to that point
yet. Sorry, but hope my suggestions help. Good Luck!

kxxxk Wrote:
Allow Excel to work off of Excelnn.xlb and XLStart located under the
Documents and Settings\All Users folder instead of the individual
\Username
folders. On my personal computer I have an Administrator account for
normal
use and a Limited Access User account for Internet browsing and email,
as
recommended for security. I would like the same Excel configuration
(Toolbars and Macros) for both accounts. This can be done in Word by
putting
the Normal template in a folder accessible to both, and pointing Word
in both
accounts to that folder for templates. In Excel, however, something
similar
cannot be done so that toolbar & macro changes by me as one user (e.g.,
the
Administrator) are automatically available to me as the other user(s)
(the
Limited Access User(s)).
--
kxxxk


--
PapaBear56

You don't have to worry about the toolbar for future excel (Office 2007),
it's gone as we know it
There are no toolbars to attach etc
--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"kxxxk" wrote in message
...
The problem is not Personal.xls (the macros) in XLStart, the problem is
with
Excellnn.xlb (Excel11.xlb in Excel 2003) which contains the toolbar
customizations and is always stored in C:\Documents and
Settings\Username\Application Data\Microsoft\Excel. If Excel is opened in
the Username account, Excel 2003 always goes to this location and opens
the
Excel11.xlb that is therein. If there is no such file at that location,
Excel opens with its default toolbar configuration. Changes in toolbars
are
always saved on closing to Excel11.xlb at that same (Username) location.
There is no getting around this currently. (Note that Excel 2003 does NOT
use C:\Program Files\Microsoft Office\Office11\XLStart\Book.xlt as Excel
Help
says it does in "Customize How Excel Starts". As I recall, Excel 97 used
to
use such a template.) My request is that the Administrator account be
allowed an option to have Excel use Excel11.xlb (in its opening and in its
closing - in its saving of toolbar modifications) in the folder
C:\Documents
and Settings\ALL USERS\Application Data\Microsoft\Excel _regardless of the
Username account in which Excel is opened_, so that those of us with
personal
computers can always access our current configuration of Excel whether we
are
using either our Administrator account or our Limited-Access-User account
to
avoid spyware being put on our machine when Internet connected.--
kxxxk


"PapaBear56" wrote:


Just a thought... You could try making a shortcut of your XLSTART file
from your administrator account and place it in your limited access
account in place of the XLSTART file there. I'm not sure Excel will
recognize the shortcut file or not.

Another method which, someone else would have to help you with the
code, is possibly a macro that would run when you start Excel in your
limited access account that would copy and then open the administrator
account's XLSTART file to your limited access account. I'd try and help
you with the code but my macro writing skills aren't up to that point
yet. Sorry, but hope my suggestions help. Good Luck!

kxxxk Wrote:
Allow Excel to work off of Excelnn.xlb and XLStart located under the
Documents and Settings\All Users folder instead of the individual
\Username
folders. On my personal computer I have an Administrator account for
normal
use and a Limited Access User account for Internet browsing and email,
as
recommended for security. I would like the same Excel configuration
(Toolbars and Macros) for both accounts. This can be done in Word by
putting
the Normal template in a folder accessible to both, and pointing Word
in both
accounts to that folder for templates. In Excel, however, something
similar
cannot be done so that toolbar & macro changes by me as one user (e.g.,
the
Administrator) are automatically available to me as the other user(s)
(the
Limited Access User(s)).
--
kxxxk


--
PapaBear56