Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Most of the time when I use macros, they are workbook specific. I put them
in to speed up a repetitive action. I recently put a macro in my Personal.xlsb file to have it accessible for all workbooks. This morning, I opened a workbook which was made to transfer data from an old workbook to this new one. My "Transfer" button first looked at the number of Workbooks and if the Count was 2, would check certain cell entries to be sure the file it was going to be transferring from is of the correct setup. When I clicked this button this morning, the macro wouldn't run because Workbooks.Count is now 3, with the third one being Personal.xlsb. Actually, I am going to expand on my questions with this first post. 1. How can I get Personal.xlsb to not Count as a Workbook, but still have the macros available? 2. When I go to the VBE, I don't really want to see my Personal macros. Can I hide those from VBE until I want to add or change the Personal file? Personal.xlsb is hidden. -- TIA, Brad E. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you "very hide" a workbook? | Excel Programming | |||
hide personal.xlsb file without closing | Excel Discussion (Misc queries) | |||
How to hide workbook "title bar" | Excel Discussion (Misc queries) | |||
Will using a "personal macro workbook" slow down my other VBA code | Excel Programming | |||
Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming |