ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File created with VB is hidden (https://www.excelbanter.com/excel-programming/311792-file-created-vbulletin-hidden.html)

J Baird

File created with VB is hidden
 
I have some code that opens an Excel file, then saves it to another Excel
file, in Excel 2000.

After the program is run, whenever a user opens the new file in Excel, they
can't automatically see the file. They have to click [Window][Unhide]
select the filename, and click [OK] to display the file.

What command do I have to add ot the VB code, to make the file display
normally when a user opens it at a later date?

Notes:
- The original file's not hidden.
- This happens if I use an Excel Template file, or an Excel xls file, then
save it in vb.




All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com