ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB IDE always activated when I unlock my computer. (https://www.excelbanter.com/excel-programming/297105-vbulletin-ide-always-activated-when-i-unlock-my-computer.html)

Craig Jordan

VB IDE always activated when I unlock my computer.
 
Hi all,

I have added some VBA code to my Excel spreadsheet--just a
few recorded macros and some other custom written public
subs in a Module file associated to a specific excel
spreadsheet. Now whenever I unlock my computer and this
Excel file is loaded, the VBA IDE for the Excel file is
activated--but it's toolbars are missing.

I can X the VBA IDE and continue working--so it's not a
functional problem, just an annoyance.

This happens even when I haven't explicitly launched the
visual basic editor using Tools | Macro | Visual Basic
Editor (Alt+F11).

Any ideas how to prevent this behavior?

Thanks,
Craig.


All times are GMT +1. The time now is 06:58 AM.

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