View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PapaBear56
 
Posts: n/a
Default An Option for future Excels


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