Disable Menu (CommandBar) if not workbook is opened

  • Thread starter Thread starter LuisE
  • Start date Start date
L

LuisE

I have a menu from an Add-In, when all workbooks are closed and all the other
menus are disabled mine remains enabled.
How can I disabled it so if someone clicks it no error message is generated?
Just as the built-in ones.

Thanks in advance
 
Thanks Ron, merry Christmas by the way.

Yes I did.
My concern is that the Add-In will remain installed even if not workbook in
opened so I'd imagine that it is technically not closed, is it?
 
A add-in will close when you close Excel.

Can you explain more what you want ?
Do you have problems when people use your menu with no workbook open ?
 
You can add this to your macro if you not want to run the code if there is no
workbook open.
If there are a lot of macros you can also build a function to do the test so you only
have to add one code line to each macro.

On Error GoTo QuitOpen
ActiveWorkbook.Activate
'Your macro code
Exit Sub
QuitOpen:
MsgBox "There is no file open", , "YourProgName"
Exit Sub
 
It works fine, thank you ron

Ron de Bruin said:
You can add this to your macro if you not want to run the code if there is no
workbook open.
If there are a lot of macros you can also build a function to do the test so you only
have to add one code line to each macro.

On Error GoTo QuitOpen
ActiveWorkbook.Activate
'Your macro code
Exit Sub
QuitOpen:
MsgBox "There is no file open", , "YourProgName"
Exit Sub
Click to expand...
 
Back
Top