There are a number of settings in Excel that I don't like and I have to change everytime I enter new data, and I am trying to find a way to automate these changes.
For example:
how can I ensure that all cells in new worksheets or workbooks have vertical alignment set to Top, without having to change it manually ?after creation of the new worksheet?
how can I ensure that a new pivot table has Autoformat disabled?
how can I ensure that a new external ODBC query has the Save password with query property enabled?
etc...
I guess I can achieve that by add-hoc macros, associated to the events triggered by the creation of the new objects indicated above. What I am looking for is a generic solution to change the default settings of future objects, rather than a case-by-case approach
For example:
how can I ensure that all cells in new worksheets or workbooks have vertical alignment set to Top, without having to change it manually ?after creation of the new worksheet?
how can I ensure that a new pivot table has Autoformat disabled?
how can I ensure that a new external ODBC query has the Save password with query property enabled?
etc...
I guess I can achieve that by add-hoc macros, associated to the events triggered by the creation of the new objects indicated above. What I am looking for is a generic solution to change the default settings of future objects, rather than a case-by-case approach