asked on

Code that will hide and unhide my PERSONAL.XLSB workbook in Excel 2010

I have a lot of macros that activate other workbooks in a specific relative order and I need some code that will hide my personal workbook, run the macro, and then unhide it when the macro is done.

I want to leave it open for the purposes of running some of its macros, and for recording new macros.

Thanks,
John

[ fanpages ]

Hi John,

I am confused by your requirements.

Why does your personal workbook need to be hidden?

If it is because the "lot of macros that activate other workbooks in a specific relative order" do not account for the presence of a personal workbook, & subsequently ignore processing of such a workbook? If so, why not change the code to do this?

BFN,

fp.

John Carney

ASKER

Hi BFN, thanks for posting. That wouldn't be a big deal, but I can see situations where the number and order of ActivateNexts and ActivatePreviouses will differ, so I figured it would be slicker to just hide and unhide the personal workbook. I googled it but couldn't find any code that addressed my situation well enough.

So if you do happen to have a hide/unhide workbook code, please let me know.

Thanks,
John

ASKER CERTIFIED SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rory Archibald