Editing a worksheet while running a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that is accessed via a macro. All interaction with the
spreadsheet is through userforms. For everyone other than the administrator
(me), that is all of the access that is needed.
However, as administator, I find that sometimes a need to directly edit the
spreadsheet data. I want to do this while not terminating the macro execution.

Is there a way in which I can pause the macro, access the worksheets, and
then resume the macro?
 
If by pause the macro you mean leave the userform up and work with the
spreadsheet, then try activating your userform like this:

UserForm1.Show vbModeless
DoEvents

This will allow you to interact with the spreadsheet while userform1 is
still up.
 
Something didn't work correctly with that.

For some reason when I try to open the userform vbModeless, it actually
displays a new worksheet and I don't get my form displayed at all.
 
try...
userform1.show false
--
JNW


Dan Perkins said:
Something didn't work correctly with that.

For some reason when I try to open the userform vbModeless, it actually
displays a new worksheet and I don't get my form displayed at all.
Click to expand...
 
You must log in or register to reply here.

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

including macro in protected worksheet 2
Hide Screens While Macro is Running 4
Commandbar will not refresh while macro is running 3
Activate a moacro subroutine from a userform command button 1
macro to refresh from Access and then 2
Sheet selection on Autoclose 2
pausing macro while cells update 6
Viewing/editing Macros 1

Back
Top