Toggling Excel files (.xlsb) with macros.

[politicus]

I am trying to create a workflow that would let me do the following after hitting a keyboard shortcut :

 

- Launch one specific .xlsb file with macros

- If the this file is already opened, toggle visibility for the file. 

 

The thing is this file has macros. So, every time I hit my keyboard shortcut, Excel closes my file (without asking me if I want to save it), then opens a window where I have to select between "Enable Macros", "Do Not Open","Disable Macros". As I want to enable the macros I have to use my trackpad to select "Enable Macros". Then opens my file. At last!

 

It would be cool if there was a way to toggle visibility for Excel files with macros the same way we can toggle visibility for applications.

[deanishe]

2 minutes ago, politicus said:

It would be cool if there was a way to toggle visibility for Excel files with macros the same way we can toggle visibility for applications.

 

Yes, it would. But this is clearly 100% an Excel thing, so what exactly are you expecting on an Alfred forum?

 

Just out of interest, like. But what is your actual question for Alfred users?

[politicus]

@deanishe I saw it as an Alfred question. I thought maybe I was using the wrong Alfred action or forgot to check a setting...

 

My bad. 

[politicus]

The solution is pretty simple. Just toggle Excel via a keyboard shortcut.

As the file is already opened, it will be displayed.

 

 

[deanishe]

Glad you got it working. Did you just do tell application "Excel" to activate?

[politicus]

No. Just a basic keyboard shortcut + open application workflow.