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)
 
Back
Top