ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add-in (https://www.excelbanter.com/excel-programming/381562-add.html)

DRA

Add-in
 
I have an add-in that i load at EXCEL startup and modify all the time. When I
open VBA, its modules usually aren't displays as it is for any modules of
workbooks. How can I ensure they are displayed and in the same place as when
I save the add-in?

Thanks,
DRA

Chip Pearson

Add-in
 
I've never heard of that happening before. Something in the VBA code (as
stored internally, not as you wrote it) is screwed up. I would use Rob
Bovey's Code Cleaner to rebuild your VBA Project. See
http://www.appspro.com/Utilities/CodeCleaner.htm .

Rob's Code Cleaner is a "must have" for serious Excel developers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"DRA" wrote in message
...
I have an add-in that i load at EXCEL startup and modify all the time. When
I
open VBA, its modules usually aren't displays as it is for any modules of
workbooks. How can I ensure they are displayed and in the same place as
when
I save the add-in?

Thanks,
DRA




DRA

Add-in
 
Cool!

Thanks,
dra

"Chip Pearson" wrote:

I've never heard of that happening before. Something in the VBA code (as
stored internally, not as you wrote it) is screwed up. I would use Rob
Bovey's Code Cleaner to rebuild your VBA Project. See
http://www.appspro.com/Utilities/CodeCleaner.htm .

Rob's Code Cleaner is a "must have" for serious Excel developers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"DRA" wrote in message
...
I have an add-in that i load at EXCEL startup and modify all the time. When
I
open VBA, its modules usually aren't displays as it is for any modules of
workbooks. How can I ensure they are displayed and in the same place as
when
I save the add-in?

Thanks,
DRA






All times are GMT +1. The time now is 09:27 AM.

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