Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Good day. I am using Excel 2003 on Windows XP Pro. A few days ago I submitted a question to the board concerning the use of an option titled Precision as Displayed.
I received an answer from one of the board regulars very quickly. The answer however, led to more questions, some of which were answered by the same person, but not all of them.
May I post the unanswered question here. I would assume that when a flag in the Options menu is set, it will affect every file that is opened in Excel from that point on. Is this true?
If so, is there a way to cause a macro to run automatically whenever particular files get opened? This would allow me to use the Precision as Displayed function on selected workbooks and not on others. I would then have to have two macros, one for setting the flag and another for removing the flag setting.
I currently have over 100 workbooks that are associated with the operation of my store. Most of the workbooks could take advantage of the Precision as Displayed flag and allow me to remove all of the ROUND functions that have been put in my formulas to circumvent the floating point arithmetic problems.
Thank you for any response to this issue.
Danno...
I received an answer from one of the board regulars very quickly. The answer however, led to more questions, some of which were answered by the same person, but not all of them.
May I post the unanswered question here. I would assume that when a flag in the Options menu is set, it will affect every file that is opened in Excel from that point on. Is this true?
If so, is there a way to cause a macro to run automatically whenever particular files get opened? This would allow me to use the Precision as Displayed function on selected workbooks and not on others. I would then have to have two macros, one for setting the flag and another for removing the flag setting.
I currently have over 100 workbooks that are associated with the operation of my store. Most of the workbooks could take advantage of the Precision as Displayed flag and allow me to remove all of the ROUND functions that have been put in my formulas to circumvent the floating point arithmetic problems.
Thank you for any response to this issue.
Danno...