software

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

gt;
gt; Just a thought... You could try making a shortcut of your XLSTART file
gt; from your administrator account and place it in your limited access
gt; account in place of the XLSTART file there. I'm not sure Excel will
gt; recognize the shortcut file or not.
gt;
gt; Another method which, someone else would have to help you with the
gt; code, is possibly a macro that would run when you start Excel in your
gt; limited access account that would copy and then open the administrator
gt; account's XLSTART file to your limited access account. I'd try and help
gt; you with the code but my macro writing skills aren't up to that point
gt; yet. Sorry, but hope my suggestions help. Good Luck!
gt;
gt; kxxxk Wrote:
gt; gt; Allow Excel to work off of Excelnn.xlb and XLStart located under the
gt; gt; Documents and Settings\All Users folder instead of the individual
gt; gt; \Username
gt; gt; folders. On my personal computer I have an Administrator account for
gt; gt; normal
gt; gt; use and a Limited Access User account for Internet browsing and email,
gt; gt; as
gt; gt; recommended for security. I would like the same Excel configuration
gt; gt; (Toolbars and Macros) for both accounts. This can be done in Word by
gt; gt; putting
gt; gt; the Normal template in a folder accessible to both, and pointing Word
gt; gt; in both
gt; gt; accounts to that folder for templates. In Excel, however, something
gt; gt; similar
gt; gt; cannot be done so that toolbar amp; macro changes by me as one user (e.g.,
gt; gt; the
gt; gt; Administrator) are automatically available to me as the other user(s)
gt; gt; (the
gt; gt; Limited Access User(s)).
gt; gt; --
gt; gt; kxxxk
gt;
gt;
gt; --
gt; PapaBear56
gt;

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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;kxxxkquot; gt; wrote in message
...
gt; The problem is not Personal.xls (the macros) in XLStart, the problem is
gt; with
gt; Excellnn.xlb (Excel11.xlb in Excel 2003) which contains the toolbar
gt; customizations and is always stored in C:\Documents and
gt; Settings\Username\Application Data\Microsoft\Excel. If Excel is opened in
gt; the Username account, Excel 2003 always goes to this location and opens
gt; the
gt; Excel11.xlb that is therein. If there is no such file at that location,
gt; Excel opens with its default toolbar configuration. Changes in toolbars
gt; are
gt; always saved on closing to Excel11.xlb at that same (Username) location.
gt; There is no getting around this currently. (Note that Excel 2003 does NOT
gt; use C:\Program Files\Microsoft Office\Office11\XLStart\Book.xlt as Excel
gt; Help
gt; says it does in quot;Customize How Excel Startsquot;. As I recall, Excel 97 used
gt; to
gt; use such a template.) My request is that the Administrator account be
gt; allowed an option to have Excel use Excel11.xlb (in its opening and in its
gt; closing - in its saving of toolbar modifications) in the folder
gt; C:\Documents
gt; and Settings\ALL USERS\Application Data\Microsoft\Excel _regardless of the
gt; Username account in which Excel is opened_, so that those of us with
gt; personal
gt; computers can always access our current configuration of Excel whether we
gt; are
gt; using either our Administrator account or our Limited-Access-User account
gt; to
gt; avoid spyware being put on our machine when Internet connected.--
gt; kxxxk
gt;
gt;
gt; quot;PapaBear56quot; wrote:
gt;
gt;gt;
gt;gt; Just a thought... You could try making a shortcut of your XLSTART file
gt;gt; from your administrator account and place it in your limited access
gt;gt; account in place of the XLSTART file there. I'm not sure Excel will
gt;gt; recognize the shortcut file or not.
gt;gt;
gt;gt; Another method which, someone else would have to help you with the
gt;gt; code, is possibly a macro that would run when you start Excel in your
gt;gt; limited access account that would copy and then open the administrator
gt;gt; account's XLSTART file to your limited access account. I'd try and help
gt;gt; you with the code but my macro writing skills aren't up to that point
gt;gt; yet. Sorry, but hope my suggestions help. Good Luck!
gt;gt;
gt;gt; kxxxk Wrote:
gt;gt; gt; Allow Excel to work off of Excelnn.xlb and XLStart located under the
gt;gt; gt; Documents and Settings\All Users folder instead of the individual
gt;gt; gt; \Username
gt;gt; gt; folders. On my personal computer I have an Administrator account for
gt;gt; gt; normal
gt;gt; gt; use and a Limited Access User account for Internet browsing and email,
gt;gt; gt; as
gt;gt; gt; recommended for security. I would like the same Excel configuration
gt;gt; gt; (Toolbars and Macros) for both accounts. This can be done in Word by
gt;gt; gt; putting
gt;gt; gt; the Normal template in a folder accessible to both, and pointing Word
gt;gt; gt; in both
gt;gt; gt; accounts to that folder for templates. In Excel, however, something
gt;gt; gt; similar
gt;gt; gt; cannot be done so that toolbar amp; macro changes by me as one user (e.g.,
gt;gt; gt; the
gt;gt; gt; Administrator) are automatically available to me as the other user(s)
gt;gt; gt; (the
gt;gt; gt; Limited Access User(s)).
gt;gt; gt; --
gt;gt; gt; kxxxk
gt;gt;
gt;gt;
gt;gt; --
gt;gt; PapaBear56
gt;gt;