to use excell i must make a lot of changes to excell defaukts, visuall basic allows, trusted docs, etc, i want to make these setting to apply to every user that loggs into the mac hine. How can i do this?
thanks in advance
Technology Tips and News
to use excell i must make a lot of changes to excell defaukts, visuall basic allows, trusted docs, etc, i want to make these setting to apply to every user that loggs into the mac hine. How can i do this?
thanks in advance
Hi,
My understanding is that you want to create an identical Excel template/custom setting for every user profile in the same pc. Is it correct? If yes, we might to the two steps:
One: Save the custom workbook as a template (XX.xltx)
Two: Distribute the XLTX file to the Excel XLStart folder. It's usually located here:
C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
or here:
C:\Program Files\Microsoft Office\OFFICE14\XLSTART
If I misunderstood something, please feel free let me know.
Regards,
George Zhao
I think i mighthave not explained my self well. I set trusted documets visual basic acceptances and other excell defaults. that are not document related, but rater relaated to she setting of excel it self. These i want to duplicate for any user that loges into the computer.
Thank you
Hi,
Sorry for reply delay, do you mind explaining your request more detailed about >>I set trusted documets visual basic acceptances and other excell defaults.<<?
Thanks,
George Zhao
Thanks George here is a link to exactly what I am trying to do https://mega.co.nz/#!axcBCZrL!omwtY4tQMRONTHfMZLG6UiUBhRx3mmWw3a4jcKW2Flk
..Ira
OK, I see. My understanding is that you want to set these options by default for the machine. I suggest we use Office ADMX template via Group policy.
More reference:
https://technet.microsoft.com/en-us/library/cc178992.aspx?f=255&MSPPError=-2147217396
George Zhao