Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() ActiveWorkbook.ToggleFormsDesign --- in spite of it's name, this seems to only switch design mode ON. How can I turn it OFF again? Thanks for any ideas! Ed |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It's Catch-22. As soon as you run a macro design mode ends. So
ActiveWorkbook.ToggleFormsDesign sets it on again. However, it will toggle when run it on another workbook/project: Workbooks("Book2").ToggleFormsDesign -- Jim "Ed Schwartz" wrote in message ... | | ActiveWorkbook.ToggleFormsDesign | | --- in spite of it's name, this seems to only switch design mode ON. | How can I turn it OFF again? | | Thanks for any ideas! | | Ed | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Issue with "ToggleFormsDesign" a method of Excel workbook | Excel Worksheet Functions |