An Option for future Excels

K

kxxxk

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)).
 
P

PapaBear56

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

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

kxxxk

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
 
P

Peo Sjoblom

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
 
Top