ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Status Bar : Display both Sum and Count (https://www.excelbanter.com/excel-programming/339721-re-status-bar-display-both-sum-count.html)

S K

Status Bar : Display both Sum and Count
 
Hello Norman Jones,

Thanks! that helps. I was wondering if I have to cut and paste this in
every workbook!? Can't this be available on the excel immeterial of
which work book (file) I'm working on?

-Keerthy


*** Sent via Developersdex http://www.developersdex.com ***

Norman Jones

Status Bar : Display both Sum and Count
 
Hi Keerthy,

Open a new workbook and paste the code into the ThisWorkbook module. Then,
save the workbook, with a suitable name, selecting 'Template' in 'Save as
Type' dropdown.

Thereafter, any workbook opened from the template, will have the same
functionality.

If you truly want this code in *all* new workbooks, then open the default
workbook template (Book.xlt) in the XLSTART folder, paste the code and save.

---
Regards,
Norman



"S K" wrote in message
...
Hello Norman Jones,

Thanks! that helps. I was wondering if I have to cut and paste this in
every workbook!? Can't this be available on the excel immeterial of
which work book (file) I'm working on?

-Keerthy


*** Sent via Developersdex http://www.developersdex.com ***





All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com