Toggle between Desin and Run mode

A

avi

Hello,

For various reasons, I need to toggle between DESIGN and RUN mode in
the same procedure.

I know how to enter DESIGN mode but the problem is that the procedure
stop after entering the DESIGN mode and does'nt continue to the line
that performs the Exit design mode

Is ther some way to get it done in the same procedure?

Thanks
Avi
 
J

Jim Rech

Is ther some way to get it done in the same procedure?

No. By definition a workbook cannot be in design mode at the same time its
macros run.

--
Jim
| Hello,
|
| For various reasons, I need to toggle between DESIGN and RUN mode in
| the same procedure.
|
| I know how to enter DESIGN mode but the problem is that the procedure
| stop after entering the DESIGN mode and does'nt continue to the line
| that performs the Exit design mode
|
| Is ther some way to get it done in the same procedure?
|
| Thanks
| Avi
|
 
A

avi

Hello,

For whom who may be interested, i'e found that the toggle is possible
if it is done externally through a VB6 exe procedure (with an On
error resume next)

Avi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

run procedure when exit design mode 3
(Word 2016/365) Removing white space between pages at a smaller zoom 0
toggle between method and source of inputs 0
Prompt For Replace in Selection And More... 0
Switch between Design Mode and "Running" Mode 1
User controls on sheet question. - How to toggle between design and execute mode? 1
How to toggle between insert and overwrite mode 1
mysteriously enters into break mode 4

Top