Open Excel Template in New Session

[Sofistikat]

I have created an interactive form in VBA which removes all menus and command bars when macros are enabled, and handed this over to our IT team. In turn, the IT team have placed the form in Templates over our Network.

But, many users are facing the problem of all of their other open Excel documents also lossing menus and command bars once the macros in the template are activated.

Ideally, it would be great to have the Template open in a brand new session of Excel so that it doen't cause any other open documents any grief.

I didn't realise that the form was going to be distributed via templates, and thought that each relevant user would get their own copy, so now I have to find a solution, like yesterday a couple of years ago.

At my wit's end, and any help will go greatly towards preserving what little sanity I still have remaining.

[davesexcel]

You obviously have a code that reactivates the menus and command bars when you close the workbook.
It may be a good idea to place that code in the workbook module such as

Please Login or Register  to view this content.

Then of course the code to remove the menus and tool bars will have to be run when you activate the workbook again.

Please Login or Register  to view this content.

If it is a named VBA code in a regular module, you would just have to call the code for each action.

[Sofistikat]

Believe it or not Dave, that's exactly what I was just trying to do, but commands like :

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"", TRUE/FALSE)"
Application.DisplayFullScreen = True/False
Application.CommandBars("Worksheet Menu Bar").Enabled = True/False

are all refusing to be nice.

[Sofistikat]

Got it. Created Functions in one of the Modules and used Run in the Workbook_Activate/Deactive event handlers to get them to work......had to reorder some of the commands as I think some were cancelling others out.

Thank you for confirming that I was on the right track, Dave....it's amazing what can be accomplished out of desperation!