Hello everyone,
Two Questions here:
Question 1: I made a program to test data in excel for work that I want to have set up with certain view settings (hide formula bar, gridlines, etc.). The purpose of this workbook is to be shared with a group of people and the workbook looks fine when I look at it on my computer, but when I open the document on another user's computer they go to the default Excel settings. Is there a way to easily set the default view settings for a workbook for other users when the open the workbook? I imagine there is maybe a way i could program a macro, but that leads to my next question.
Question 2: Also, when I open the workbook on another user's computer a message comes up that macros have been disabled and need to be enabled. All they have to do is press "Enable" and they work fine, but I would like them to just automatically be enabled to avoid someone not enabling them. Is there a way to automatically enable the macros for a workbook that is shared with other people or will I just have to make sure other users click "Enable" when they first open the document?
Thanks in advance!
Two Questions here:
Question 1: I made a program to test data in excel for work that I want to have set up with certain view settings (hide formula bar, gridlines, etc.). The purpose of this workbook is to be shared with a group of people and the workbook looks fine when I look at it on my computer, but when I open the document on another user's computer they go to the default Excel settings. Is there a way to easily set the default view settings for a workbook for other users when the open the workbook? I imagine there is maybe a way i could program a macro, but that leads to my next question.
Question 2: Also, when I open the workbook on another user's computer a message comes up that macros have been disabled and need to be enabled. All they have to do is press "Enable" and they work fine, but I would like them to just automatically be enabled to avoid someone not enabling them. Is there a way to automatically enable the macros for a workbook that is shared with other people or will I just have to make sure other users click "Enable" when they first open the document?
Thanks in advance!