Excel - creation in the background with VBA/ Access

  • Thread starter gangac via AccessMonster.com
  • Start date
G

gangac via AccessMonster.com

I create an excel workseet from access that runs on the users desktop-
however, as it is being created/populated in VBA/access, ( even though I have
screen update=false) the sheet is open and it is possible that the user start
typing into the worksheet and cause an error in the sheet output. Is it
possible for me to lock the entire worksheet/any other way of preventing
editing by the user till the sheet has been fully populated and only then
open it to the user for editing.

thanks and regards,
Chandran gangadharan
 
K

Klatuu

I alway set the following 3 properties:

xlApp.DisplayAlerts = False
xlApp.Interactive = False
xlApp.ScreenUpdating = False
 

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

Running ms access modules as admin but logged into access as a regular user.. 2
How to create portable Excel applications? 2
Set Read Only property in Excel from Access VBA 2
Excel crashes and restarts when accessing newly created worksheet 2
Macro to Consolidate Data from Various Excel Files 1
VBA Macro Training in Chennai 0
Renaming Excel Worksheet Names after creation in VBA 5
VBA Performance in Access vs Excel 7

Top