Hide startup.xls

[Meadin]

Hello,

So the situation is this:

We have a *companyname* startup.xls file stored on the network that is being copied to all users when they are logging on to their machines.
In this file we have all macro's present that are used by the company.

Now when people open a excel file it automatically opens this workbook as well. So you have the startup.xls open and the file the users
want to use.

I want to hide this startup.xls excel instance. Tried it with a simple Macro code:

Sub HideStartup()
Windows("******* Startup.xls").Visible = False
End Sub

but this did not work.

Any help greatly appreciated!!

[joe31623]

Try including the ActiveWindow.Visible = False line right after the workbook is opened.

Please Login or Register  to view this content.

Although, I would assume Startup.xls contains a few macros and has a .xlsm extension.

You can also save Startup.xls/Startup.xlsm in a hidden state by (with Startup.xls/Startup.xlsm open within Excel) navigating to Window>Hide and hide it. Then shut down Excel. When prompted whether or not you want to save changes to Startup.xls/Startup.xlsm, click Save. Then, if you open it up, it will open up hidden (so you won't see it).

Also, be sure to surround your code with code tags like I did because it is required per the Forum rules. We are asked not to respond to posts such as yours until they comply with all forum rules, but I didn't catch that and cannot delete my post. You do that by writing: "["Code"]" before any code is written (without the quotes); and just after the last line of code, you write: "["/Code"]" (again, without the quotes).

[Meadin]

Thanks for the tip, i will try and post the result here.

Ok, i did not know that. Will do in the future.

[Meadin]

Unfortunate i get this message:
example2.jpg
I create it as a new macro...
Sorry i am not (yet) familiar with macros...

[Meadin]

Anyone know?