ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Missing VBA Project References for non-VBA commands (https://www.excelbanter.com/excel-discussion-misc-queries/125722-missing-vba-project-references-non-vba-commands.html)

Rock Chalk Julie

Missing VBA Project References for non-VBA commands
 
I have recently encountered a problem that whenever I try to change a cell I
get an error message about missing VBA references. It occurs whether I'm
trying to change text, numerical data, or formulas. To my knowledge (I took
over for someone else working on this project), there is no VBA anywhere in
the spread sheet

The reference it says its missing is Blue Sky Software Active Popup. I've
tried unchecking it, but it won't allow me as it says it's "currently in
use." If I click OK or cancel, it goes ahead and allows me to do what I
wanted.

As I know nothing about VBA, it's all rather Greek to me. Any suggestions
on how to not make this occur everytime?

Thanks!



Rock Chalk Julie

Missing VBA Project References for non-VBA commands
 
One other note that may help figure out what the problem is: Sometimes if I
completely close out of Excel and come back, it will stop giving me that
error message for a while.

"Rock Chalk Julie" wrote:

I have recently encountered a problem that whenever I try to change a cell I
get an error message about missing VBA references. It occurs whether I'm
trying to change text, numerical data, or formulas. To my knowledge (I took
over for someone else working on this project), there is no VBA anywhere in
the spread sheet

The reference it says its missing is Blue Sky Software Active Popup. I've
tried unchecking it, but it won't allow me as it says it's "currently in
use." If I click OK or cancel, it goes ahead and allows me to do what I
wanted.

As I know nothing about VBA, it's all rather Greek to me. Any suggestions
on how to not make this occur everytime?

Thanks!




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

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