run a macro when a file opens

[caliskier]

Is it possible to set up a macro when a file is opened it automatically does the following steps:

Select “instructions” sheet
Hide rows 1-5
Set password to ou
Select “Orders” sheet

All without showing that it did this?

I want to use this as a safety in case we forget to do it when we close the file. So if it already in place doing it again will not hurt anything.

[VBA Noob]

Maybe

Code goes in ThisWorkbook module

Please Login or Register  to view this content.

VBA Noob

[caliskier]

Maybe

Code goes in ThisWorkbook module

Please Login or Register  to view this content.

VBA Noob

Thanks VBA, you rock as always...

[VBA Noob]

Your welcome

VBA Noob

[caliskier]

Ok, but one problem though, if it is already hidden then it give me a debug error. How do you override this?

[caliskier]

Ok, I figured it out the error is caused because it is trying to hide on a protected sheet. I put unprotect before it hides and it works weather it is protected or not.

[VBA Noob]

Could use

Please Login or Register  to view this content.

or try

Please Login or Register  to view this content.

VBA Noob