Unhide the Application Window

  • Thread starter Thread starter Sal Veltri
  • Start date Start date
S

Sal Veltri

I have vba code in an Access program that calls and manipulates data in
an Excel spreadsheet. All the manipulation code works fine. This
spreadsheet is unsecured (by design) and can be viewed by anyone. The
problem is that after my code works on the file, the next time it is
opened (not by any code) the application is hidden and the user must go
to the menu bar and manually unhide the window. Is there code to
rectify this situation?

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
This is a guess.

If your users have to use Window|Unhide to unhide that workbook, then maybe your
code is doing something bad.

Any chance that yow wanted to hide excel:
xlApp.visible = false

and instead are hiding the workbook???
xlWkbk.visible = false

(with nice Dim's and Set's)
 

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

Back
Top